如何在vb6中将.xls与.csv进行比较 [英] how to compare .xls to .csv in vb6

问题描述

嗨！
有人可以帮我完成我的项目吗?
我需要创建一个程序，在其中需要比较.xls和.csv文件中的发票编号. .xls中有3列(客户编号，发票编号，发送日期)，. csv中有10列(无标题)，. csv中的发票编号位于第3列，每张发票的状态为第二列.如果状态为1表示接受，2处理，3收集，则需要在.xls文件的第5列(在.csv中)中比较并显示每个发票的状态.

我只启动了其中有2个文本框(.xls的第一个文本框和.csv的第2个文本框)的界面，并且添加了命令按钮，因此如果单击此按钮，过程将开始.

我不知道如何启动主要流程，请帮助我.
非常感谢

Hi!
Can anyone help me with my project?
I need to create a program where in I need to compare the invoice# in .xls and in .csv file. In the .xls there are 3 column (customer number, invoice#, date sent) and in .csv there are 10 columns (no header), the invoice# in .csv is located in 3rd column and the status of each invoice is in 2nd column. I need to compare and show the status of each invoice in the .xls file 5th column (in .csv) if the status is 1 means accepted, 2- processed, 3- collected.

I only started the interface where in I have 2 text boxes (1st text box for .xls and 2nd for .csv), and I added a command button so if I click this the process will start.

I don''t know how to start the main process, please help me.
Thanks a lot

推荐答案

[阅读不佳的编辑-感谢Carlo]

尝试此 [此 [此 [

[edit for poor reading - thanks Carlo]

Try this[^] for Excel.

This[^] mauy help you in reading in the XML and this[^] should help you reading the CSV.

Define a class that combines the data from both files.
Load the data into instances of the class.
Now process the class instances rather than the raw data.

您能给我示例代码来做到这一点吗?谢谢.

can you give me sample code on how to do this? thanks.

这篇关于如何在vb6中将.xls与.csv进行比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！