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