抽取Excel文件 [英] Decimating Excel files

问题描述

不，我不想摧毁他们（有趣的是，''''''''''''''''''''''''''''''''''''''）
我们有一个数据采集程序，可以将其输出保存为Excel的


我想了解一些如何去做的建议 ：

1.读取一个大型Excel文件并将其切割成许多Excel文件（

每个文件只有65535行）

或

2.取消Excel文件&写...说每隔一行（用户

可选）...到一个新文件。


我在阅读和写作方面经验丰富简单的文本文件，但

这是我第一次尝试使用COM。我想，无论选择1

还是2，一旦我打开文件就非常简单。


提前致谢。

解决方案

2月3日，1：43？pm，gonzlobo< gonzl ... @ gmail.comwrote：

不，我不想摧毁他们（有趣的是，''''''''''''''''''''''''''''''''''''''$ $ $ $ $ $ $ $ $ $ $ $ $
我们有一个数据采集程序，可以将其输出保存为Excel的


我想了解一些如何去做的建议 ：

1.读取一个大型Excel文件并将其切割成许多Excel文件（

每个文件只有65535行）

Excel工作表只有65535行。或者你是否意味着它有多张表？
$ blockquote class =post_quotes>
或

2.取消Excel文件&写...说每隔一行（用户

可选）...到一个新文件。

Excel有VBA，可以轻松完成。关于

Excel'的VBA的一点是它已经了解Excel。

>

I 我在阅读和编写简单的文本文件方面经验丰富，但

这是我第一次尝试使用COM。我想可以选择1

或2，一旦我可以打开文件就非常简单。

是否有.xls文件而不是应用程序？

>

提前致谢。

谢谢，但我一直在寻找一个python解决方案。

Excel有VBA，可以轻松完成。关于

Excel'的VBA的一点是它已经了解Excel。

gonzlobo写道：

2.取消Excel文件&写...说每隔一行（用户

可选）...到一个新文件。

其他每一行都是二元化的东西，

不是吗？


-

Greg

No, I don''t want to destroy them (funny how the word ''decimate'' has
changed definition over the years) :).

We have a data acquisition program that saves its output to Excel''s
..xls format. Unfortunately, the programmer was too stupid to write
files the average user can read.

I''d like some advice on how to go about:
1. Reading a large Excel file and chop it into many Excel files (with
only 65535 lines per file)
or
2. Decimate an Excel file & write... say every other line (user
selectable)... to a new file.

I''m pretty experienced at reading and writing simple text files, but
this is my first foray into using COM. I would imagine either choice 1
or 2 is pretty simple once I can get the file open.

Thanks in advance.

解决方案

On Feb 3, 1:43?pm, gonzlobo <[e-mail]:

No, I don''t want to destroy them (funny how the word ''decimate'' has
changed definition over the years) :).

We have a data acquisition program that saves its output to Excel''s
.xls format. Unfortunately, the programmer was too stupid to write
files the average user can read.

I''d like some advice on how to go about:
1. Reading a large Excel file and chop it into many Excel files (with
only 65535 lines per file)

An Excel sheet only has 65535 lines. Or do yo mean it has
multiple sheets?

or
2. Decimate an Excel file & write... say every other line (user
selectable)... to a new file.

Excel has VBA and can do this easily. One thing about
Excel''s VBA is that it already understands Excel.

>
I''m pretty experienced at reading and writing simple text files, but
this is my first foray into using COM. I would imagine either choice 1
or 2 is pretty simple once I can get the file open.

Is it the case where you have .xls files but not the application?

>
Thanks in advance.

Thanks, but I was looking for a python solution.

Excel has VBA and can do this easily. One thing about
Excel''s VBA is that it already understands Excel.

gonzlobo wrote:

2. Decimate an Excel file & write... say every other line (user
selectable)... to a new file.

Every other line would be bicimating or something,
wouldn''t it?

--
Greg

这篇关于抽取Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！