Our Training Programs

All contents are copyright of their authors.

.xlsx file format conversion

.xlsx file format conversion

Swayam Rath

8yAsked Jan 3, 2018, 1:52 PM801Learn iOS Programming

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

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

alice yang8y ago
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
Amit Gupta8y ago
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.
Swayam Rath8y ago
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
Amit Gupta8y ago
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.