How does an xlsx file work?
What are the disadvantages of .xls files vs .xlsx?
What is an XLSX file? - News - ONLYOFFICE Community
How to open .xlsx file directly with Excel WEB, on PC that doesn't have Excel installed?
What is an XLSX viewer?
Which XLSX viewers convert spreadsheets to PDF?
Are there free XLSX viewers online?
Videos
I have a file that should be structurally very similar to an excel spreadsheet. I want to create a mobile app to read that file, i do not intend to do this to sell it, just for person use (i would use it for work). I tried opening the file with different softwares, but they can just show me the binary and obviously that is no help. If i try to open it with a python algorithm it just returns an error on a byte (unable to decode). The software this file generates is obviously programmed in microsoft visual c++, so i am assuming the file has the same structure as an xlsx file (also because the software works a lot like excel), but online i can't find anything about how excel saves its data in the file. So my question is, how is the structure of an excel spreadsheet? Even if you can give me resources to read from, that would be very appreciated. Thanks in advance
The company that provides my database software has, in a bizarre move, removed the ability to export data to .xlsx files, allowing only .xls instead.
I'm making a complaint to them, but I feel like my complaint would carry more weight with some specifics about the problems with .xls files... I'd appreciate if anyone could give me some good reasons why .xls is inadequate!
What I know of the differences so far are:
-
the much smaller row and column limits in xls files
-
xls files can contain macros, so I guess they're a security risk
-
xls files seem to take up at least 50% more disk space
-
A couple of colleagues reckon that it takes much longer to export xls files - this makes sense I suppose if the files are larger, but is there another reason for it?
-
(this one is presumably specific to my database provider) The xls exports have text qualifiers (') in every non-numeric field. Fields that should be recognised as boolean display as text. So far, macros that read the boolean value in those cells still work, and "=IF(A2,1,0)" still works, but "=IF(A2=TRUE,1,0) does NOT work.
Any further insight would be greatly appreciated!
PS this is probably a bit different from the usual posts on this sub, I hope I've complied with the rules!
Edit: I now realise I probably should have tagged this as a discussion, as there isn't really a solution per se. Might leave it open for a while longer in case there are any other interesting comments or suggestions before I mark one lucky commenter with "Solution verified", in the meantime, thanks to everyone for your insight and knowledge :)
Edit 2: thanks to the mod who changed the tag to discussion!
So company upgraded to Window 10 Server, and we don't have Office installed anymore. We are forced to WEB apps now.
I have bunch of Excel files on Desktop and I don't want them accessed only through OneDrive folder.
Is there a way to somehow link .xlsx extension to Excel WEB? As well as Word extension.