By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,587 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,587 IT Pros & Developers. It's quick & easy.

reading from text file to excel file

P: n/a
Hi,
I do not know if this is right place for this, but i need some help. I
have a text file, whose values are seprated by a delimiter. I want to
open this file in excel, ( not import it) . I have written the driver
prg in c#. The code opens the file, but it is not writting the values
from text file into excel file. I can not figure out the problem here.
This is my code:
StreamReader dataFileReader = null;
FileInfo file = null;
Excel.Application ExcelObj = new Excel.Application();
Excel.Workbook workbook = null;
Excel.Range currentCell = null;
Excel.Worksheet worksheet = null;
string txtoutput = null;
Excel.Sheets excelSheets = null;
Excel.Range sampleResults = null;
}
public void transformation()
{
try
{
//GC.Collect();
workbook =
ExcelObj.Workbooks.Add(Excel.X*lWBATemplate.xlWBAT Worksheet);
excelSheets = workbook.Worksheets;
worksheet =
(Excel.Worksheet)excelSheets.g*et_Item(1);
if (worksheet == null)
{
Console.WriteLine ("ERROR in
worksheet == null");
}
// Opens the text file.
string inFile ="C:\\dip\\output2.txt";
using (StreamReader reader = new
StreamReader(inFile) )
{
String currentLine;
sampleResults =

worksheet.get_Range("A1", Type.Missing);
int row = 1;
int count = 0;
// Populates the table of
sample results.
// Continues reading lines
until there are no more.
while ((currentLine =
reader.ReadLine()) != null)
{
count++;

Console.WriteLine("Reading string # {0} to populate excel row #
{1}", count, count);
string[] textInfo =
currentLine.Split(',');
// Places each sample
result into the appropriate cell.
for (int i = 0; i <
textInfo.Length; i++)
{
currentCell =

(Excel.Range)sampleResults.Cel*ls[row, i+1];

currentCell.Value2 =
textInfo[i].Trim();
}
row++;
currentLine =
reader.ReadLine();
}

//thisWorkbook.SaveAs("C://dip*//test.xls",Excel.XlFileFormat*.xlWorkbookNormal,

null,null,false,false,Excel.Xl*SaveAsAccessMode.xl Shared,fals*e,false,null,null);
workbook.SaveAs("C://dip//test*.xls",Excel.XlFileFormat.xlWor*kbookNormal,

null,null,false,false,Excel.Xl*SaveAsAccessMode.xl Shared,fals*e,false,null,null);

}
}
catch(Exception ex)
{
//Debug.WriteLine(ex.Message +
ex.StackTrace);

Console.WriteLine("{0}\n{1}",e*x.Message,ex.StackT race);
//Thread.Sleep(3000);
}
finally
{
//excelTW.Close();
//dataFileReader.Close();
//delete files for one time usage
//File.Delete(output2);
//close resources, allocated for the
Excel process
workbook.Close(false, Type.Missing,
Type.Missing);
ExcelObj.Workbooks.Close();
ExcelObj.Quit();

//System.Runtime.InteropServic*es.Marshal.ReleaseCom Object
(currentCell);

//System.Runtime.InteropServic*es.Marshal.ReleaseCom Object
(ExcelObj);

//System.Runtime.InteropServic*es.Marshal.ReleaseCom Object
(worksheet);

//System.Runtime.InteropServic*es.Marshal.ReleaseCom Object
(workbook);
worksheet=null;
workbook=null;
ExcelObj = null;
//try to force GC
GC.Collect();
}
}

Nov 14 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"ma************@yahoo.com" <ma************@yahoo.com> writes:
I do not know if this is right place for this, but i need some help. I
have a text file, whose values are seprated by a delimiter. I want to
open this file in excel, ( not import it) . I have written the driver
prg in c#.

[SNIP]

No, this isn't the right place. C and C# are two different languages;
we only know about one of them here. You probably want one of the
microsoft.* groups, or perhaps comp.os.ms-windows.programmer.

--
Keith Thompson (The_Other_Keith) ks***@mib.org <http://www.ghoti.net/~kst>
San Diego Supercomputer Center <*> <http://users.sdsc.edu/~kst>
We must do something. This is something. Therefore, we must do this.
Nov 14 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.