How to force Microsoft Excel (.xlsx) files to use only inline strings for cellvalues

R, Divya 0 Reputation points
2023-05-08T11:28:26.8533333+00:00

whenever I edit Microsoft Excel file *.xlsx manually, the cell values are stored as SharedString. How can I force editing cell values in .xlsx files to use only inline strings?
Or any compatible xls file formats which supports 400K rows with only inline strings?

Note: I am facing very bad performance issues reading .xlsx files(400K rows and 8 columns) with SharedString CellValues through OpenXML library. It is read faster if the excel file has only inline strings.

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.