Work with Excel table in ASP.NET web application
I have MS Word form with some fields and to these fields I can insert Excel tables.
Now I have to convert this Word form into web application form, web app is written in ASP.NET开发者_如何学运维.
I there some way to make possible inserting Excel tables using web app(copy-paste from Excel, keep formatting, not need formulas - only data), storing them in DB and show back in web app?
Thanks a lot
Assuming you're using MS SQL Server?
If you can get those tables into an Excel file, you can use SQL Server Management Studio's Import/Export Wizard to import data into a table from an Excel file.
精彩评论