Comments (14)
@xuri The xls spec if pretty heavy duty and entirely different from reading xlsx. I think it would be reasonable to say we won't support the legacy xls format and close this and the related issues.
from excelize.
@xuri Any update yet?
from excelize.
I'd really like to know, why are you using xls instead of xlsx in 2023? Is it macro support?
Same on this issue's comment here: #341 (comment)
That's because my company is still using the XLS
format as a default instead. Sadly! :(
from excelize.
see https://github.com/extrame/xls
from excelize.
So we have to use a totally different library for
xls
? Hmm.. 🤔
It seems that you have to use a different library. The other one is easy to use. If you are going to use it, consider that it has a incorrect master branch tagging and you will have to go get github.com/extrame/xls/xls@4a6cf263071b975a90abf74ca3e804b48243be28
from excelize.
xlsx was introduced with Microsoft office 2007 and can be read with zip + xml parsers. It supports far more rows and allows for compression.
xls is a binary format, is limited to ~65k rows, and parsing it requires an entirely separate set of tools: https://interoperability.blob.core.windows.net/files/MS-XLS/%5bMS-XLS%5d.pdf
I'd really like to know, why are you using xls instead of xlsx in 2023? Is it macro support?
from excelize.
I really don't see this getting added to the library due to the complexity involved. Like I said, it's not a similar implementation at all.
Java has Apache POI: https://poi.apache.org/ which is probably your most complete, free option.
There's a go wrapper for libxls: https://github.com/godzie44/go-xls
Over on the C# side if you have Windows there are some free libraries that support interop to office and can do conversion. If you're not on Windows (and that's unlikely for your server, and probably a risk to install there anyway) there are some paid libraries.
There's also a Python library: https://pypi.org/project/xlrd/
from excelize.
@CodyGuo Thanks for your issue. The legacy XLS use Object Linking and Embedding (OLE) format, it's completely different with OOXML and can't be supported by the same code. To support this feature maybe needs to evaluate.
from excelize.
@xuri Thank you, waiting for your good news.
from excelize.
a conclusions yet?
from excelize.
Any update on this topic? I really need to read xls
file instead, due to business format usage.
from excelize.
Thank you!!!
from excelize.
So we have to use a totally different library for xls
? Hmm.. 🤔
from excelize.
The github.com/extrame/xls
lib is too old now and has a lot of bugs. The biggest/critical bug I think is extrame/xls#56 that, I don't think will get fixed soon.
If this lib is not support all functionalities for XLS
, maybe make a conversion function somehow to convert it to XLSX
so we can use this lib in peace? :)
from excelize.
Related Issues (20)
- Parentheses in formulas get cut out when inserting new columns or rows HOT 1
- Feature request: SetRowHeight for StreamWriter HOT 1
- Tab (\t) character cannot be displayed in the generated workbook's cell HOT 1
- condition A with style ,the unstyled condition will be applied with A's style. HOT 1
- excelize按行读取内容成字符串数组导致日期格式错误 HOT 1
- The first execution of Flush() data will be written to Excel, and SetRow() after Flush() will not take effect HOT 1
- duration has -1 second HOT 2
- Excel to PDF Page Size issue HOT 1
- After adding and saving images in Excel by excelize, the GetPictureCells method cannot read any values HOT 1
- Support insert the Kingsoft WPS Office embedded image cells via the DISPIMG formula function HOT 2
- [BUG] Get Rows function HOT 1
- Count columns and rows of the worksheets. 会提供 Max row Max col 属性吗 HOT 1
- Open a Microsoft Excel sheet which been set password, in code not provide “Options” cause “zip: not a valid zip file” HOT 2
- I have 70 option datas,but can't set dropList as datavalidation HOT 1
- Remove column caused workbook corrupted HOT 1
- Font size of the header and footer doesn't work HOT 2
- sw.SetRow() Can only be called once HOT 3
- Wrong (outdated) module path in go.mod HOT 1
- Support for more built-in langNumFmt allows GetCellValue to fetch dates and times in more localizations
- Getting "expected element <workbook> in name space http://schemas.openxmlformats.org/spreadsheetml/2006/main but have no name space" FileOpen and SaveAs afterwards HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from excelize.