Import Excel (xlsm) data to DataSet using C# in ASP.Net

amar

SOLVED CLOSED ACTIVE ANSWERED
User: amar
Posted: on Apr 08, 2020 09:38 AM
Forum: Data Controls
Answer: 1
Views: 4701

How to import xlsm data to Dataset

I am using below

SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbookSet().Workbooks.OpenFromStream(oFile.InputStream);
var dataSet = workbook.GetDataSet(SpreadsheetGear.Data.GetDataFlags.FormattedText);

I am facing some input stream issue corrupted xml file

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Apr 08, 2020 09:49 AM
Report

Hi amar,

Refer below links to read xlsm file to DataSet.

https://www.easyxls.com/manual/basics/import-from-xlsm-file-format.html

https://stackoverflow.com/questions/31502226/how-to-read-xls-and-xlsx-and-xlsm-files-in-c-sharp

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Import Excel (xlsm) data to DataSet using C# in ASP.Net

Company

Explore

Follow us

Contact Us