DevOps and System Administration Discussions
Dive into SAP DevOps and system administration. Join discussions to collaborate on optimizing workflows, share knowledge, and leverage resources effectively.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert Various excel format to simple xlsx which will have sharedStrings.xml

0 Kudos
316

Problem:

I am using Java apache poi-3.17 and doing Export and Import of xlsx.

But when i export xlsx and save it , the xml format is different

1. <c r="B2" s="3" t="inlineStr"> but when i import i will be comparing t ="s",

and in workbook.xml it starts from r:id="rId3", but it starts with r:id="rId1" when we do save as of any xlsx.

2. sharedStrings.xml is not there when we export

So is there any api which will take different format xlsx and convert it into default xlsx.

0 REPLIES 0