jscript, sample code needed to open plain text file and use as excel97 file

sample code needed to open plain text file and use as excel97 file

Author	Message
Evan Chua Ya #1 / 3	sample code needed to open plain text file and use as excel97 file hi all! could someone tell me what's the best way to do the following programmatically? i already have a JScript that performs data scrubbing on an excel97 file. some of the files that get to me however are plain text files (assume they're tab delimited). i know i can manually import a tab limited text file into excel (first bringing up the open file dialog, then going thru the text import wizard screens) then start manipulating it. how can i do this programmatically so that after the text import, i can manipulate the result as an excel file object? i don't even have to save the file as a .XLS FILE, since the end product of my data scrubbing manipulations will be another tab-delimited text file. (i'm assuming here that by reusing the JScript file i already have, i can save time by not having to write yet more custom code to do similar data scrubbing operations on non-excel97 input files). any help will be greatly appreciated
Tue, 15 Jan 2002 03:00:00 GMT

Michael Harri #2 / 3	sample code needed to open plain text file and use as excel97 file Check the docs for Excel.Workbooks.OpenText(blah,blah) method... Excel 97 Language Reference http://msdn.microsoft.com/library/officedev/office97/output/F1/D3/S5A... OpenText method http://msdn.microsoft.com/library/officedev/office97/output/F1/D3/S5A... -- Michael Harris \| hi all! \| could someone tell me what's the best way to do the following \| programmatically? \| \| i already have a JScript that performs data scrubbing on an excel97 \| file. \| \| some of the files that get to me however are plain text files \| (assume they're tab delimited). \| i know i can manually import a tab limited text file into excel \| (first bringing up the open \| file dialog, then going thru the text import wizard screens) then \| start manipulating it. \| \| how can i do this programmatically so that after the text import, i \| can manipulate the result \| as an excel file object? i don't even have to save the file as a \| .XLS FILE, since the end \| product of my data scrubbing manipulations will be another \| tab-delimited text file. \| (i'm assuming here that by reusing the JScript file i already have, \| i can save time by not \| having to write yet more custom code to do similar data scrubbing \| operations on \| non-excel97 input files). \| \| any help will be greatly appreciated \| \|
Tue, 15 Jan 2002 03:00:00 GMT

Evan Chua Ya #3 / 3	sample code needed to open plain text file and use as excel97 file thanks, michael Quote: > Check the docs for Excel.Workbooks.OpenText(blah,blah) method... Excel > 97 Language > Referencehttp://msdn.microsoft.com/library/officedev/office97/output/F1/D3/S5A... OpenText > methodhttp://msdn.microsoft.com/library/officedev/office97/output/F1/D3/S5A... > -- > \| could someone tell me what's the best way to do the following > \| programmatically? > \| > \| i already have a JScript that performs data scrubbing on an > excel97 > \| file. > \| > \| some of the files that get to me however are plain text files > \| (assume they're tab delimited). > \| i know i can manually import a tab limited text file into excel > \| (first bringing up the open > \| file dialog, then going thru the text import wizard screens) > then > \| start manipulating it. > \| > \| how can i do this programmatically so that after the text > import, i > \| can manipulate the result > \| as an excel file object? i don't even have to save the file as > a > \| .XLS FILE, since the end > \| product of my data scrubbing manipulations will be another > \| tab-delimited text file. > \| (i'm assuming here that by reusing the JScript file i already > have, > \| i can save time by not > \| having to write yet more custom code to do similar data > scrubbing > \| operations on > \| non-excel97 input files). > \| > \| any help will be greatly appreciated > \| > \|
Tue, 15 Jan 2002 03:00:00 GMT

Page 1 of 1

[ 3 post ]