CODEWITHSUNDEEP
c#c#-4.0
Patan
Patan

Reputation: 17893

creating excel sheet and writind data into it

I am working on writing the data into Excel sheet in c#.

I have wriiten the following code.

        string excel_filename = @"C:\Users\Downloads\bookmain.xlsx";
        Excel.Application excel = new Excel.Application();
        excel.Visible = true;
        Excel.Workbook wb = excel.Workbooks.Open(excel_filename);
        Excel.Worksheet sh = wb.Sheets.Add(); 
        sh.Name = "TestSheet"; 
        sh.Cells[1, "A"].Value2 = "SNO";
        sh.Cells[1, "B"].Value2 = "Name";
        sh.Cells[1, "C"].Value2 = "ID";
        for (int i = 0; i < 2; i++)
        {
            sh.Cells[i+2, "A"].Value2 = "1";
            sh.Cells[i+2, "B"].Value2 = "A";
            sh.Cells[i+2, "C"].Value2 = "1122"; 
        }


        wb.Save();
        excel.Quit();

Here I have given the path of excel file that already exists and it is empty.

How to change this code that, when i give the path it should automatically check, if it exists it have to create otherwise no need to create.

Even my code also need to check sheet name, it it exist i shall directly edit it or else I need to create a new sheet.

Can any one share their response.

Thank you.

Upvotes: 0

Views: 3852

Answers (1)

Pranav
Pranav

Reputation: 8871

for checking existence of file :

if(!File.Exists(excel_filename)) 
{
  //if not exists then only create:- 
}

and for checking worksheet you can do like :

foreach (Sheet sheet in workbook.Sheets)
{
    if (sheet.Name.equals("Test"))
    {
        //do something
    }
}

UPDATED : this is how it works :

Create Excel object

Excel.Application excel = new Excel.Application();

make Excel visible

excel.visible = true

add a worksheet

Excel.Worksheet sh = wb.Sheets.Add();

save it as

  wb .SaveAs( @"C:\Users\Downloads\bookmain.xlsx",
            Excel.XlFileFormat.xlXMLSpreadsheet, missing, missing,
            false, false, Excel.XlSaveAsAccessMode.xlNoChange,
            missing, missing, missing, missing, missing);

Upvotes: 4

Related Questions