How to pass FieldInfo parameter to Workbooks::OpenText(...) in VC+

L

Lily

Hi,

I am using Excel Automation from VC++ MFC code, I need to read .txt file and
display in Excel, I have some data like 1234E2, I wish to to display it as
"1234E2", but currently it is displayed as 123400. I need to disable this
scientific convertion. I studied the OpenText(...) function, and find that we
can specify the fieldinfo to do correct read. but I don't know how to pass
parameter for FieldInfo. anybody can help?

thks a lot in advance.

Lily,
 
D

Dave Peterson

I don't use VC++, but if you open excel and record a macro when you open that
text file (and choose the correct field types), you'll see what excel expects.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SOS-How to pass array parameter to Workbooks.OpenText(...) in VC++ 1
How to access Fieldinfo? 0
Can we Pass String to FieldInfo Array to OpenText Method. 0
How to pass parameters to excel from wscript (Windows script) 5
Pass string as Parameter in OpenText method 0
Problem with OpenText in Excel 2000 (date format) 1
How to read excel file in VC++ 1
Pass a worksheet as a parameter to a function? 4

Top