By the way, i think we have already talked about this subject at How to insert data into open office excel from sql server using c#, if you have any extra related question, please feel free to let me know
in that thread instead of opening another two same threads, you can use the "Reply" button to keep on in the same thread.
None
0 Points
3 Posts
how to insert data into sqlserver from open office excel using asp.net,c#
Oct 29, 2019 12:55 PM|bobinscaria|LINK
how to insert data into sqlserver from open office excel using asp.net,c#
(for already existing excel and new excel)
Participant
1700 Points
533 Posts
Re: how to insert data into sqlserver from open office excel using asp.net,c#
Oct 30, 2019 02:15 AM|Yang Shen|LINK
Hi bobinscaria,
Do you mean you want to read from an opening excel file?
As far as i know, this is not possible because the process will be locked my your MSOffice.
I made a demo based on code from Read Excel as DataTable using OpenXML and C#, and if i was trying to read an opening excel, the program will throw below exception:
By the way, i think we have already talked about this subject at How to insert data into open office excel from sql server using c#, if you have any extra related question, please feel free to let me know in that thread instead of opening another two same threads, you can use the "Reply" button to keep on in the same thread.
Best Regard,
Yang Shen