Is it possible to write a large table into a binary file? How?

JFz
2015 8 31
2 个回答
更新时间：2015 8 31
4 次查看（30 天）

0 个投票

I have a large table. If I write it into a text file, it is huge. Is it possible to write a large table into a binary file? If yes, how?
I googled this subjest, but all the links only refer to non-table type. For table, writetable function does not mention binary file.
Thanks.
Jennifer

2 个评论
显示 无 隐藏 无

Sean de Wolski
Sean de Wolski 2015-8-31
Do you need to open it outside of MATLAB? If not, just use save and save it using -v7.3 which will compress it.
JFz
JFz 2015-8-31
Thanks. I do need to open it with Excel VBA code.
I tried save and I can save it ito a .mat file. And the size is shrinked to 1/10 of the text file size, which is really what I wanted. But how to open it with VBA is a question.

请先登录，再进行评论。

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

回答（2 个）

Walter Roberson
Walter Roberson 2015-8-31

0 个投票

How about if you write it to a .xls file? You could specify 'FileType', 'spreadsheet' but it should assume that for .xls file extensions.

2 个评论
显示 无 隐藏 无

JFz
JFz 2015-8-31
Write to .xls file? With just writetable(T, 'T.xls')? Let me try. Thanks.
JFz
JFz 2015-8-31
Just tried. The file size is even bigger than text file. I want to reduce the text file size.

请先登录，再进行评论。

Image Analyst
Image Analyst 2015-8-31

0 个投票

Exactly how big is "huge" to you?
You can use writetable() to write a binary file. For example an .xlsx file is binary. Or you could use a .mat file by calling save(). Or you could just do it real low level by calling fwrite() yourself.

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Walter Roberson
Walter Roberson 2015-8-31
.xlsx is XLM which is text based, not binary.
JFz
JFz 2015-8-31
It is about 40M. It has over 7 million rows and 6 columns.
JFz
JFz 2015-8-31
I looked at save() but I didn't see anywhre about binary. Did I miss anything there?
Image Analyst
Image Analyst 2015-8-31
It's a proprietary format. Ultimately, everything in digital computers is binary. I suggest you just don't care about that and only worry about what the final size is, if that matters to you. But 40 MB is somewhat large, but I wouldn't call it huge. I regularly work with images a hundred times that size.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

提问:

JFz
JFz
2015-8-31

评论：

Image Analyst
Image Analyst
2015-8-31

Community Treasure Hunt

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

Start Hunting!

Translated by