PDA

View Full Version : How to copy contents of text file to tab sheet of another excelsheet



ahjiefreak
07-12-2008, 07:54 AM
I have two files..file A and file B.

File A is text file which has contents to be copied over.
File B is excel(XLS) file which has different tabs in the fileB itself.

I wanted to copy content of file A to one of the tabs in File B. Assume I have other files such as File C,D,E to be copied to File B but of other tabs in File B.

For your information, I am using Gnumeric to open the XLS.

Please let me know as i try google around for few mths.

Thanks alot.

Rgrds.

Simon Lloyd
07-12-2008, 04:46 PM
There's a worked example here (http://en.allexperts.com/q/Excel-1059/Importing-Text-Files-Excel.htm)

ahjiefreak
07-13-2008, 05:05 AM
Hi,

Thanks for the prompt reply.

Maybe I should explain another word for the "tab". The "tabs" which I meant is:-

in excel spreadsheet , there are different tabs belong to the same excel spreadsheet. For e.g File B(the excel spreadsheet) has 5 tab sheets in the spreadsheet itself.

Another question is ,if this is supportable in Gnumeric or only for Microsoft Excel?

Rgrds,
Jason