.xlsx file format conversion

Question

Hello Everyone,

 

We generate an excel report from a tool in a defined format(file is attached INPUT.xlsx).

However we would like to convert that to another format(file is attached OUTPUT.xlsx).

Could i get some help in developing the logic to parse input.xlsx and produce output.xlsx?

 

thanks in advance.

 

Regards,

Swayam 

Answer 1

For reading/writing of excel files, you can either use Interop.Excel or OLEDb. OleDb only used for read/write (no formatting). If you want any formatting like borders and stuffs then you have to go for Interop.Excel.

Answer 2

You can also use free spire.xls library to open, read, edit and convert xlsx files, it's easy to use and doesn't need Excel to be installed. Here is the guidance for your reference:

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Spire.XLS-Program-Guide-Content.html 

Answer 3

Yeah, I saw both the files and I'm? afaraid that you have to go for a little long path to solve this. I think this can be better achieved through reading either line by line or cell by cell and after you get all the inputs, you can proceed with your expected output format.

Answer 4

Thanks Amit.

 

I was looking for some sort of help in formulating the logic to convert the input.xlsx into output.xlsx. 

Did you get a chance to have a look at those two files?

 

Regards

swayam