Skip to main content
A
aswink0004
October 11, 2023
Question

Import Excel sheet to Database (Excel sheet header name start from row 8)

  • October 11, 2023
  • 2 replies
  • 0 views

Hi, 

I have a excel sheet in which the Excel sheet headers start from different row (example: row-8).

In a process model, how can I read it from row 8 using Import excel to database smart service.

2 replies

niranjanreddym9323
niranjanreddym9323
December 11, 2023

Hi [mention:c901f717a2704058a004693e3c3a54c0:e9ed411860ed4f2ba0265705b8793d05] ,

You can read excel sheet using readexcelsheetpaging() funtion in processmodel . Within the function use pagingInfo paramter to read data from 8th row using startIndex as 8.

konduruc733182
konduruc733182
December 11, 2023

Hello aswink0004,

I would recommend to have a User Input where the selection of the row is dynamic and let the user to select the Start row.

Have a interface in your process where the user will upload the document/Excel file and it is read using the readexcelsheetpaging() and the data is collected in a variable on selection. You can try to define the batch start Index and the size of data that you want to write it to the Database. Definetely this would increase few steps in your process, but it would help your user to have a better awareness of the data that is going to be processed. (Have a display of the data as a preview before you pass it to the DB)

Terms & ConditionsAccessibility statement