How to insert bulk data into excel without using excel application scope?

Help Activities
, ,
1

I don’t have Excel in my system. So i can’t use excel application scope in my workflow. I used write range workbook but that doesn’t work for bulk data. Can anyone suggest any other option to insert bulk data into excel?

2

@jenipriya.chitravel

try using excel as DB

Also using workbook activity as well we cna update the data…please tell the error you are egtting

cheers

3

I don’t have excel application in my system that is the main concern. so i can’t able to open excel

4

@jenipriya.chitravel

ideally this works without excel as well

but you need the db providers

Also please share issue with workbook activities

cheers

5

Hi Anil,

I tried but got this error

A warning message indicating that the user is logged on with non-administrative privileges and unable to create or modify System DSNs appears on a computer screen. (Captioned by AI)
A warning message indicating that the user is logged on with non-administrative privileges and unable to create or modify System DSNs appears on a computer screen. (Captioned by AI)1015×735 32.3 KB

6

@jenipriya.chitravel

as per error you need admin priviliges reach out to your it

cheers

7

Hello @jenipriya.chitravel

You can insert data via Workbook Activities.
Without knowing your exact case you could read an existing file into a Datatable with Read Range Workbook.
Then you can inject a new row (for each of the data you need to insert) by creating and populating a DataRow variable.

Assign dtr_NewRow = dt_ExcelFile.NewRow()
Assign dtr_NewRow("Column Name 1") = "data to insert"
Assign dtr_NewRow("Column Name 2") = "other data to insert"
Etc...

Regards
Soren