How to Extract data from Read only Excel Sheets

Help
1

Hi ,
How we can get data from
read only excel file without changing the properties. wip.xlsx (8.4 KB).

and if we want to add column into it how we would do that ?

2

I would use Excel Application Scope then Read Range activity to read the xlsx file, t
then i would create new excel file with added columns

3

Hi @Navneetj3

You can use the read range activity to read the data to a datatable. If you can add new column while processing then you can use add data column activity and add the data to the datatable. Once done, you can use the write range to write the data back to a new excel sheet.

4

i tried using read range within excel application scope ,but the datatable is blank . I have attached the sheet for the reference.

5

Navneetj3.xaml (5.8 KB)

Works fine with me

6

Is it necessary to use outputdatatable activity . why we can not use dt.tostring in writeline after readrange .

Thanks for your help!
Navneet

1 Like
7

Datatable is converted to string by using output datatable…

8

In the read range activity, for output property have you provided the datatable variable?

9

Because you can’t use dt.toString since DataTable is not one dimensional

1 Like
10

Got it .
thanks to all

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.