Advertisement
Guest User

Untitled

a guest
Sep 16th, 2014
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. app = new Microsoft.Office.Interop.Excel.Application();
  2. workbook = app.Workbooks.Add(1);
  3. worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1];
  4.  
  5. //Change all cells' alignment to center
  6. worksheet.Cells.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
  7.  
  8. //But then this line changes every cell style back to left alignment
  9. worksheet.Cells[y + 1, x + 2].Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
  10.  
  11. // fill in the starting and ending range programmatically this is just an example.
  12. string startRange = "A1";
  13. string endRange = "A1";
  14. Excel.Range currentRange = (Excel.Range)excelWorksheet.get_Range(startRange , endRange );
  15. currentRange.Style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
  16.  
  17. worksheet.get_Range("A1","A14").Cells.HorizontalAlignment =
  18. Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
  19.  
  20. var range = worksheet.Range[string.Format("A{0}:C{0}", rowIndex++)];
  21. range.Merge();
  22. range.Value = "some value";
  23.  
  24. var style = workbook.AddStyle();
  25. style.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft;
  26.  
  27. range.Style = style.Name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement