Capturing format of excel while creating a new excel from old one


#1

Hi,

Please let me know how to capture the format of excel workbook… I tried creating one single excel document by capturing the data from multiple excel


#2

Not 100% sure what you mean here? If you are talking about the formatting of the Excel workbook then this is not possible with UiPath - formatting would need to be done either using templates, macros or custom activities.

If you just want to read excel files then follow this tutorial https://www.uipath.com/tutorials/excel-and-datatables-automation


#3

you could get the excel format by referring to the file’s extension (xlsx, xls, xlsb etc) - if this is what you mean…


#4

Hi,

I will give the exact scenario: I got 3 excels which has cells being formatted ( like Integer , percentage )… I automate copying the details from these 3 excels into single excel… I was successful in copying , but the formats aren’t the same… the contents are copied as General.

Please let me know if we can copy the content with its format intact.


#5

you could write a CELL formula with ui path in another column: ie.
=CELL(“format”, A1)
it will return a different letter for each format (P = percenatge, D= date, G = text etc.)
otherwise just try to get the type of the value using uipath’s .NET programming


How to read and write range from one workbook to another while keeping cell formatting?
#6

@theo500

I want to set format to Column using Uipath


#7

@richarddenton
Is there still no pre-implemented way of doing this?