/** * Creates a bar chart. API needs some work. :) * * NOTE: Does not yet work... checking it in just so others * can take a look. */ public void CreateBarChart(HSSFWorkbook workbook, HSSFSheet sheet) { List<RecordBase> records = new List<RecordBase>(); records.Add(CreateMSDrawingObjectRecord()); records.Add(CreateOBJRecord()); records.Add(CreateBOFRecord()); records.Add(new HeaderRecord(string.Empty)); records.Add(new FooterRecord(string.Empty)); records.Add(CreateHCenterRecord()); records.Add(CreateVCenterRecord()); records.Add(CreatePrintSetupRecord()); // unknown 33 records.Add(CreateFontBasisRecord1()); records.Add(CreateFontBasisRecord2()); records.Add(new ProtectRecord(false)); records.Add(CreateUnitsRecord()); records.Add(CreateChartRecord(0, 0, 30434904, 19031616)); records.Add(CreateBeginRecord()); records.Add(CreateSCLRecord((short)1, (short)1)); records.Add(CreatePlotGrowthRecord(65536, 65536)); records.Add(CreateFrameRecord1()); records.Add(CreateBeginRecord()); records.Add(CreateLineFormatRecord(true)); records.Add(CreateAreaFormatRecord1()); records.Add(CreateEndRecord()); records.Add(CreateSeriesRecord()); records.Add(CreateBeginRecord()); records.Add(CreateTitleLinkedDataRecord()); records.Add(CreateValuesLinkedDataRecord()); records.Add(CreateCategoriesLinkedDataRecord()); records.Add(CreateDataFormatRecord()); // records.Add(CreateBeginRecord()); // unknown // records.Add(CreateEndRecord()); records.Add(new SerToCrtRecord()); records.Add(CreateEndRecord()); records.Add(CreateSheetPropsRecord()); records.Add(CreateDefaultTextRecord((short)TextFormatInfo.FontScaleNotSet)); records.Add(CreateAllTextRecord()); records.Add(CreateBeginRecord()); // unknown records.Add(CreateFontIndexRecord(5)); records.Add(CreateDirectLinkRecord()); records.Add(CreateEndRecord()); records.Add(CreateDefaultTextRecord((short)3)); // eek, undocumented text type records.Add(CreateUnknownTextRecord()); records.Add(CreateBeginRecord()); records.Add(CreateFontIndexRecord((short)6)); records.Add(CreateDirectLinkRecord()); records.Add(CreateEndRecord()); records.Add(CreateAxisUsedRecord((short)1)); CreateAxisRecords(records); records.Add(CreateEndRecord()); records.Add(CreateDimensionsRecord()); records.Add(CreateSeriesIndexRecord(2)); records.Add(CreateSeriesIndexRecord(1)); records.Add(CreateSeriesIndexRecord(3)); records.Add(EOFRecord.instance); sheet.InsertChartRecords(records); workbook.InsertChartRecord(); }
public void TestTestMethods() { HSSFWorkbook wb = new HSSFWorkbook(); wb.InsertChartRecord(); //wb.dumpDrawingGroupRecords(true); //wb.dumpDrawingGroupRecords(false); }