Hi All,
Im extracting data from web page to excel. I just want to add “Start Date” column header on “A1” Cell from column “A2” data is writing. how can i add customised header to Excel.
Please suggest.
Thanks in Advance,
Niranjan
1 Like
1 Like
- Use Excel Application Scope:
- Drag and drop an “Excel Application Scope” activity.
- Specify the Excel file path within the activity.
- Add Custom Header:
- Inside the “Excel Application Scope,” use the “Write Cell” activity.
- Set the
Cellproperty to"A1"(without quotes). - Set the
Textproperty to your custom header, for example, “Start Date.”
- Write Data:
- Now, you can proceed to extract and write the data starting from cell “A2.”
1 Like
@pravallikapaluri Thank you, But other columns (B1 to G1) are filling with B2 to G2 Data. How can i make it blank B1 to G1 cells.
@lrtetala I do not have any data table for customised header, I just want to add Heading to the “A1” Cell. any suggestions please
@Krishna_Raj Im getting some error Excel Application Score: Error opening workbook.if Excel is istalled run the ‘Repair tool for Microsoft Office Interop’ from the Tools tab on the home screen.
The data is writing from A1 to G1.
So,you want to insert a row and need to add header in A1.
or
Provide the sample excel and expected output.
@pravallikapaluri I just wan to add Header on “A1” column but it is takin data from B2 and C2 and writing on B1 and C1. How can i add header on only “A1” column.
@Niranjan_k
Can you show the workflow to understand,why it is writing.
@pravallikapaluri I do not have access to office system, im uploading it from my personal system.
@pravallikapaluri Thanks a ton
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.