Hi,

I have a requirement to import a .xlsm file using file attachment control in smartform. Populate list view with the data being imported using excel file. Excel has many sheets and has header columns.

Below are the steps I have performed:

1. Created an SQL table with VarBinary column.

2. Inserted File in to SQL table from File Attachment control.

3. Called a .Net method to read the excel and fetch the required details.

But, Unable to read the excel content from Varbinary column.

Kindly suggest any way to read the xlsm file in K2.

I can see the file temperorly stored under "Program Data" folder. Is it a good practice to load file from this location and process?

Thanks in advance.

Regards,

Poornima