GSpread.NET - Google Spreadsheets .NET APIGSpread.NET

Supported functions and properties

The library is limited and supports a certain subset of Excel functions:

Object Methods Properties
  • Excel.Application
  • MailLogon
  • Quit
  • Save
  • SaveWorkspace
  • ActiveCell
  • ActiveSheet
  • ActiveWorkbook
  • Cells
  • Columns
  • DecimalSeparator
  • Range
  • Rows
  • Sheets
  • ThousandsSeparator
  • Workbooks
  • Worksheets
  • Excel.Workbooks
  • Add - templates will not be supported
  • Open - limited options set will be supported to open only google spreadsheets by name
  • Close
  • Count
  • Item
  • Excel.Workbook
  • Activate
  • Close
  • ExportAsFixedFormat - only PDF format will be supported (may be excluded from 1st version)
  • Save
  • SaveAs - only google spreadsheet format is supported)
  • ActiveSheet
  • Application
  • FullName
  • Name
  • Sheets
  • Worksheets
  • Excel.Worksheets
  • Add - only Worksheet can be added
  • Count
  • Item
  • Excel.Worksheet
  • Activate
  • Delete
  • Application
  • Cells
  • Columns
  • Name
  • Range
  • Rows
  • Excel.Range
  • BorderAround
  • Clear
  • ClearContents
  • ClearFormats
  • Insert
  • Merge
  • UnMerge
  • Address
  • Borders
  • Cells
  • Column
  • Columns
  • ColumnWidth - implemented in pixels
  • Count
  • EntireColumn
  • EntireRow
  • Font
  • Formula
  • FormulaR1C1
  • HorizontalAlignment
  • Interior
  • Item
  • NumberFormat
  • Offset
  • Range
  • Row
  • Rows
  • RowHeight
  • Style
  • Text
  • Value
  • Value2
  • VerticalAlignment
  • Worksheet
  • WrapText
  • Excel.Style
  • Borders
  • Font
  • HorizontalAlignment
  • Interior
  • NumberFormat
  • VerticalAlignment
  • WrapText
  • Excel.Font
  • Bold
  • Color
  • ColorIndex
  • Italic
  • Size
  • Strikethrough
  • Underline
  • Excel.Interior
  • Color
  • ColorIndex
  • Excel.Borders
  • Color
  • ColorIndex
  • Count
  • Item
  • LineStyle
  • Weight
  • Excel.Border
  • Color
  • ColorIndex
  • LineStyle
  • Weight