xlsx format without the com server?

1 次查看（过去 30 天）
Anon
Anon 2020-1-29
回答： Anon 2020-4-17
I would like to set (preserve) the column widths when processing an xlsx file but I'm not using windows.
How would I set column widths in these circumstances?
Ta

请先登录，再回答此问题。

回答（2 个）

Andrew Janke
Andrew Janke 2020-1-31
You need to use a third-party library like Apache POI to do this.
Coincidentally, I'm writing an Office IO API to support use cases like this. It runs on Apache POI, so it'll work on Linux and is suitable for server-side automation. It supports setting column widths and other sheet formatting.
https://github.com/apjanke/janklab/blob/master/doc/UserGuide-OfficeIO.md
This library is still in preview, but the basic Excel functionality, including column widths and row heights, is working.
Anon
Anon 2020-4-17
Andrew,
Sorry about the delay - the original answer was to me "too complicated for now". However, I would like to get this working so that I can preserve presentational elements of the .xlsx spreadsheet while still using the matlab table format to manipulate the data.
Could you post a simple example showing how to read in the coloumns widths from the orginal .xslx file and how to set them in a new file created with writetable() please? The documentation on github is a bit minimal.
Thanks!

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by