Upload CVS file convert into Excel then Fill Excel

[MSAQIBABBASI]

Hi, Team I am here to get some information about spire excel functions. that I want to know that I am uploading CSV file and then I want to convert that csv file into excel then want to fill that excel file in DataTable C#.
Thanks & Regards.

[Brian.Li]

Hello,

Thanks for your inquiry.
In fact, you can directly export the data in the CSV file to the DataTable. Please refer to to following code.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"CSVToExcel.csv", ",");
            Worksheet worksheet = workbook.Worksheets[0];

            System.Data.DataTable dataTable = worksheet.ExportDataTable();

Sincerely,
Brian
E-iceblue support team

[MSAQIBABBASI]

Hi yes I know that I can upload CSV file directly but I am trying to compare two excel file record so when I am filing both in data Table so it says Files format not match so that's why I ask you to if there's another way to convert CSV during runtime so it good to me either I have to change before uploading it CSV to Excel.
Thanks & regards.

[Brian.Li]

Hello,

Thanks for your inquiry and sorry for the late reply as weekend.
You can refer to the following code to convert csv file to excel file and then export the data in the excel file to the DataTable.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"CSVToExcel.csv", ",");
           
            workbook.SaveToFile("result.xlsx",ExcelVersion.Version2016);
            workbook.LoadFromFile("result.xlsx");
            Worksheet worksheet = workbook.Worksheets[0];
            System.Data.DataTable dataTable = worksheet.ExportDataTable();

Sincerely,
Brian
E-iceblue support team

[Brian.Li]

Hello,

Hope you are doing well.
Has your issue been resolved? Any feedback will be greatly appreciated.

Sincerely,
Brian
E-iceblue support team

[MSAQIBABBASI]

Yes my issue has been resolved. Thanks

[Brian.Li]

Okay, I am glad to hear that your issue has been resolved.
If you encounter any issues related to our products in the future, please feel free to contact us.

Sincerely,
Brian
E-iceblue support team