Put data into excel
-
Hi All, I'm trying to do simple aplication to read data from the serial port and put it into an excel spreadsheet. Acctually I'm not sure about what should I use. I rather use VC++. Could you give me just some advice to wich way should I go? Thanks in advance, Igor Kondrasovas
-
Hi All, I'm trying to do simple aplication to read data from the serial port and put it into an excel spreadsheet. Acctually I'm not sure about what should I use. I rather use VC++. Could you give me just some advice to wich way should I go? Thanks in advance, Igor Kondrasovas
hi, check this link, here the author is converting CSV to excel this might be of some help to u.. http://www.codeguru.com/mfc\_database/CSpreadSheet.html cheers.. :laugh::laugh: Himanshu
-
Hi All, I'm trying to do simple aplication to read data from the serial port and put it into an excel spreadsheet. Acctually I'm not sure about what should I use. I rather use VC++. Could you give me just some advice to wich way should I go? Thanks in advance, Igor Kondrasovas
The easiest would probably be an Excel VBScript "macro" using the MSComm object for reading from serial device. (It's amazing how much you can do in this crude language/environment...) Another option would be generating a .csv file (Comma-separated Values), which excel tends to open nicely (if lannguage settings are correct)
Those who not hear the music think the dancers are mad. [sighist] [Agile Programming]
-
Hi All, I'm trying to do simple aplication to read data from the serial port and put it into an excel spreadsheet. Acctually I'm not sure about what should I use. I rather use VC++. Could you give me just some advice to wich way should I go? Thanks in advance, Igor Kondrasovas
-
The easiest would probably be an Excel VBScript "macro" using the MSComm object for reading from serial device. (It's amazing how much you can do in this crude language/environment...) Another option would be generating a .csv file (Comma-separated Values), which excel tends to open nicely (if lannguage settings are correct)
Those who not hear the music think the dancers are mad. [sighist] [Agile Programming]
-
Is it possible to use MSComm object on .NET? I tried to convert an app from VB6 to .NET and I got erros, because the component could not be located... Cheers Igor
As it's a fairly "vanilla" COM object, it should work perfectly (just make sure it's registered on the system, and you added a reference to it to the project). I haven't tried it, though. However, under .NET should be "more native" methods to talk to the serial port. No idea which, but would probably be worth doing (if you care about performance, or want to get rid of the mscomm.dll dependency)
Those who not hear the music think the dancers are mad. [sighist] [Agile Programming]
-
Hi All, I'm trying to do simple aplication to read data from the serial port and put it into an excel spreadsheet. Acctually I'm not sure about what should I use. I rather use VC++. Could you give me just some advice to wich way should I go? Thanks in advance, Igor Kondrasovas
1.) CP has some great serial comm tutorials / classes / articles. 2.) you definately either want to write a dll or COM application and export your functions / interfaces for vb to use. - I did something similar, i created a data aquisition application in VBA (Excel) that uses a dll i wrote in straight c. The dll is a socket client that connects to intelligent hardware and collects data. I had to reformat the data in the DLL so I could export it to excel, which was a bitch, but in the end it worked perfectly. You should have no trouble what so ever. If your going the DLL route, be sure to look into IDL. Ryan Baillargeon