Right now, if your issue is to improve the extension simply after that it is instead straightforward and also can easily be actually carried out with C# without Microsoft Excel mounted in your pc as well as the documents may be additionally opened up as.xls is Microsoft Excel 97– 2003 compatible book and.xlsx illustrate the most recent stick out book layout however the modified report can easily not level unless all the relevant information reads as well as changed to the absolute most latest layout.
If office is not prepared up, you might certainly not able to use.net office interop settings up. In one my task simply recently I require to take care of altering style of much older stand out to most current stand out style, as part which our company using in our business doesn’t take care of much older layout of stand out (though its XLS, nevertheless base style is actually of stick out 1995). At opportunity we possess 2 choices either utilization MS Excel to upgrade that file or even utilize any kind of 3rd festivity software treatment.
Microsoft Office when sets up in the unit a set of dll (vibrant link public library) documents is actually included in the body’s international assembly store. For Microsoft Excel, this installation is Microsoft.Office.Interop.Excel. To enhance a file’s expansion programatically you don’t call for any such dll’s to be installed in your tool.
As MS stand apart can’t exist in each of customer computer unit, so quite first strategy runs out inquiry, so our experts worked out along with third party software program gotten in touch with Farpoint array, which provide efficiency to bunch and also save data in between several layout of stick out. You can make an effort ExcelPackage collection or even OpenXML public library for your job.
C# Regulation for transformation of data expansion is as follows, If you prefer to review all the well worths coming from the.xls file and after that change it to.xlsx after that it is certainly not feasible without Microsoft Office put up in your device.
Your finest bet is to utilize a 3rd part element such as C# ASP.NET Excel Spreadsheet Programming API for XLS XLSX CSV PDF which do not require the installation of Office.
The very best C# MS Excel library I have actually worked with is ClosedXML.
Simply one example of it’s simpleness is discovered in their GitHub Repository at ClosedXML/ClosedXML for producing a workbook, waiting, and adding a string value to cell A1.
I have actually used EPPlus (totally free open source) and iDiTect (license-required).
iDiTect is truly excellent. One requirement I had was to produce a dropdown list from the contents of a variety, something EPPlus might not do at the time (though that may not be something you need). I think I had the exact same problem with pivot table assistance.
Your question does not make much sense, however I think I comprehend what you are questioning, and I’ll attempt to address appropriately – Forgive me if the response I am providing you, is not what you’re looking for though:-RRB-.
I happen to have developed a “WASTE app generator”, that enables you to create a database WASTE web app, that allows you to import CVS files into its database. It’s produced on top of ASP. NET, in C#, and it enables you to modify your information through for circumstances your phone, utilizing your web browser.
You need some kind of library to read/write xls( x).
You can use Microsoft.Office.Interop.Excel – but then you also require to have actually Excel set up on the computer where the code is running!
Or, you can use to third part library.
When working with asp.net, I have been utilizing EpPlus, and like it really much.