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

populate a excel sheet from text file

P: n/a

Hi,
I Have a text file & I want to open it in excel sheet ( withou
importing). I have written code for it, but it is not opening exce
sheet. It opens the text file, but does not create a excel sheet
populate it. I do not know what the problem is, can someone please hel
out with this one,
Here 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.xlWBA TWorksheet)*;
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.XlFileForma*t*.xlWorkbookNormal

null,null,false,false,Excel.Xl**SaveAsAccessMode.x lShared,fal*s*e,false,null,null)

workbook.SaveAs("C://dip//test**.xls",Excel.XlFileFormat.xlWo*r*kbookNormal

null,null,false,false,Excel.Xl**SaveAsAccessMode.x lShared,fal*s*e,false,null,null)

}
}
catch(Exception ex)
{
//Debug.WriteLine(ex.Message +
ex.StackTrace);
Console.WriteLine("{0}\n{1}",e**x.Message,ex.Stack Trace);
//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.ReleaseCo mObject
(currentCell);
//System.Runtime.InteropServic**es.Marshal.ReleaseCo mObject
(ExcelObj);
//System.Runtime.InteropServic**es.Marshal.ReleaseCo mObject
(worksheet);
//System.Runtime.InteropServic**es.Marshal.ReleaseCo mObject
(workbook);
worksheet=null;
workbook=null;
ExcelObj = null;
//try to force GC
GC.Collect();
}
}
Thank

--
dgoe
-----------------------------------------------------------------------
dgoel's Profile: http://www.msusenet.com/member.php?userid=48
View this thread: http://www.msusenet.com/t-186943009

Nov 17 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.