Version History

1.5:

  • Added ExcelWriterChartSheet class.
  • Added ExcelWriterProtection class.
  • Added ExcelWriterRichText class.
  • Added SetLabelPosition method to the ExcelWriterSeries class.
  • Added SetLabelsLeaderLine method to the to the ExcelWriterSeries class.
  • Added SetLabelsNumberFormat method to the to the ExcelWriterSeries class.
  • Added SetLabelsLegend method to the to the ExcelWriterSeries class.
  • Added SetLabelsSeparator method to the to the ExcelWriterSeries class.
  • Added SetTrendLine method to the to the ExcelWriterSeries class.
  • Added SetTrendLineEquation method to the to the ExcelWriterSeries class.
  • Added SetTrendLineForecast method to the ExcelWriterSeries class.
  • Added SetTrendLineIntercept method to the ExcelWriterSeries class.
  • Added SetTrendLineLine method to the ExcelWriterSeries class.
  • Added SetTrendLineName method to the ExcelWriterSeries class.
  • Added SetTrendLineRSquared method to the ExcelWriterSeries class.
  • Added SetLabelsFont method to the to the ExcelWriterSeries class.
  • Added SetLine method on the ExcelWriterAxis class.
  • Added SetNumberFormat method on the ExcelWriterAxis class.
  • Added ExcelWriterChart.ChartTrendlineTypeValues enum.
  • Added ExcelWriterSeries.LabelPositionValues enum.
  • Added ExcelWriterSeries.LabelSeparatorValues enum.
  • Added AddChartSheet function to the ExcelWriterWorkbook class.
  • Added CellRichText method to the ExcelWriterWorksheet class.
  • Added Protect method to the ExcelWriterWorksheet class.
  • Added SetFirstSheet method to the ExcelWriterWorksheet class.
  • Added SetSelection method to the ExcelWriterWorksheet class.
  • Added SplitPanes method to the ExcelWriterWorksheet class.
  • Added SetHighLowLines method to the ExcelWriterChart class.
  • Added SetDropLines method to the ExcelWriterChart class.
  • Added 2 variations of SetUpDownBars method to the ExcelWriterChart class.
  • Added new Example project to explain ChartSheets.
  • Added new Example project to explain Protection on sheets.
  • Added new Example project to explain multi style text in cells.
  • Added new Example project that shows complex Chart data tools.

    1.3:

  • Added ExcelWriterDataValidation class.
  • Fixed inserting pictures from Xojo objects (PNG) (broke in version 1.2 but worked in 1.1)
  • Fixed inserting pictures from Xojo objects (JPG) (broke in version 1.2 but worked in 1.1)
  • ExcelWriterChartFont.Size property is now double instead of Int16 to enable floating point fonts.
  • ExcelWriterFormat.FontSize property is now double instead of Int16 to enable floating point fonts.
  • Added ApplyDataValidation methods (2 variations) to the ExcelWriterWorksheet class.
  • Added new example project for data validation.

    1.2:

  • Added missing Console safe flag on ExcelWriterWorkbook.Create shared method (both variations).
  • Added missing Console safe flag on ExcelWriterSheet.NameToRow shared method.
  • Added missing Console safe flag on ExcelWriterSheet.NameToColumn shared method.
  • Added missing Console safe flag on ExcelWriterSheet.NameToLastColumn shared method.

    1.1:

  • Added ExcelWriterChartFont class.
  • Added ChartAreaSetPattern method to the ExcelWriterChart class.
  • Added PlotAreaSetPattern method to the ExcelWriterChart class.
  • Added SetNameFont method to the ExcelWriterChart class.
  • Added SetNameFont method to the ExcelWriterAxis class.
  • Added SetNumberFont method to the ExcelWriterAxis class.
  • Added SetLegendFont method to the ExcelWriterChart class.
  • Added HideSpecificSeries method to the ExcelWriterChart class.
  • Added InvertIfNegative property to the ExcelWriterSeries class.
  • Added DoughnutHoleSize property to the ExcelWriterChart class.
  • Added PrintingSetRepeatColumns method to the ExcelWriterWorksheet class.
  • Added PrintingSetRepeatRows method to the ExcelWriterWorksheet class.

    1.0:

  • This is the first version.