Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Excel.Workbook xlWorkBook;
- Excel.Worksheet xlWorkSheet;
- object misValue = System.Reflection.Missing.Value;
- xlWorkBook = xlApp.Workbooks.Add(misValue);
- xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
- //Write Column Headers
- xlWorkSheet.Cells[1, 1] = "Name";
- xlWorkSheet.Cells[1, 2] = "Address";
- xlWorkSheet.Cells[1, 3] = "Phone Number";
- xlWorkSheet.Cells[1, 4] = "Postal Code";
- xlWorkSheet.Cells[1, 5] = "Region";
- xlWorkSheet.Cells[1, 6] = "Locality";
- //Populate cells with participant information
- xlWorkSheet.Cells[i + 1, 1] = participantName[i];
- xlWorkSheet.Cells[i + 1, 2] = participantAddress[i];
- xlWorkSheet.Cells[i + 1, 3] = participantNumber[i];
- xlWorkSheet.Cells[i + 1, 4] = participantPostalCode[i];
- xlWorkSheet.Cells[i + 1, 5] = participantRegion[i];
- xlWorkSheet.Cells[i + 1, 6] = participantLocality[i];
- //Save Workbook and safely close it
- xlWorkBook.SaveAs("c:\csharp-Excel.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
- xlWorkBook.Close(true, misValue, misValue);
- xlApp.Quit();
- //Release the objects
- releaseObject(xlWorkSheet);
- releaseObject(xlWorkBook);
- releaseObject(xlApp);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement