Format an Excel column (or cell) as Text in C#?

by

Below is some code to format columns A and C as text in SpreadsheetGear for .NET which has an API which is similar to Excel – except for the fact that SpreadsheetGear is frequently more strongly typed. It should not be too hard to figure out how to convert this to work with Excel / COM:

IWorkbook workbook = Factory.GetWorkbook();
IRange cells = workbook.Worksheets[0].Cells;
// Format column A as text.
cells["A:A"].NumberFormat = "@";
// Set A2 to text with a leading '0'.
cells["A2"].Value = "01234567890123456789";
// Format column C as text (SpreadsheetGear uses 0 based indexes - Excel uses 1 based indexes).
cells[0, 2].EntireColumn.NumberFormat = "@";
// Set C3 to text with a leading '0'.
cells[2, 2].Value = "01234567890123456789";
workbook.SaveAs(@"c:\tmp\TextFormat.xlsx", FileFormat.OpenXMLWorkbook);

Disclaimer: I own SpreadsheetGear LLC

More Related Contents:

  1. Import and Export Excel – What is the best library? [closed]
  2. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  3. Download Excel file via AJAX MVC
  4. How to detect installed version of MS-Office?
  5. Export DataTable to Excel with EPPlus
  6. Excel Interop – Efficiency and performance
  7. Exception from HRESULT: 0x800A03EC Error
  8. How to write some data to excel file(.xlsx)
  9. Excel to DataTable using EPPlus – excel locked for editing
  10. How to export a JQgrid data to Excel using c#?
  11. Fastest way to interface between live (unsaved) Excel data and C# objects
  12. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  13. Is there any simple way to convert .xls file to .csv file? (Excel)
  14. Export DataTable to Excel with Open Xml SDK in c#
  15. C# create/modify/read .xlsx files
  16. Microsoft.Office.Interop.Excel really slow
  17. How to read single Excel cell value
  18. Get instance of Excel application with C# by Handle
  19. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  20. Programmatically getting the last filled excel row using C#
  21. EPPlus Large Dataset Issue with Out of Memory Exception
  22. Reading Excel Files as a Server Process
  23. Is csv with multi tabs/sheet possible?
  24. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  25. Reading from Excel (Range into multidimensional Array) C#
  26. How to know if a cell has an error in the formula in C#
  27. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  28. How to read more than 256 columns from an excel file (2007 format) using OLEDB
  29. Running an Excel Macro via C#: Run a macro from one workbook on another?
  30. .Net Excel Interop Deleting a worksheet

Leave a Comment