Hello dear,
Hope you are doing great.
I was checking the text extractions for the .xlsx files, but unfortunately i ran into a problem that it only extracts strings from the file and ignores numbers which is not the case in the .xls files. I have checked the source code in the github.
In the file document-management-system/src/main/java/com/openkm/extractor/SpreadsheetMLContentHandler.java
method: public String getFilePattern() {
return "xl/sharedStrings.xml";
}
Gets info from sharedStrings.xml file from the excel zip file which contains only strings and ignore numbers.
Hope you are doing great.
I was checking the text extractions for the .xlsx files, but unfortunately i ran into a problem that it only extracts strings from the file and ignores numbers which is not the case in the .xls files. I have checked the source code in the github.
In the file document-management-system/src/main/java/com/openkm/extractor/SpreadsheetMLContentHandler.java
method: public String getFilePattern() {
return "xl/sharedStrings.xml";
}
Gets info from sharedStrings.xml file from the excel zip file which contains only strings and ignore numbers.
Attachments
screen.png (77.65 KiB) Viewed 1918 times
(8.51 KiB) Downloaded 168 times
screen2.png (137.76 KiB) Viewed 1918 times