Build 3.5.0.18 of xlsgen is a continuation of
build 3.5.0.8 which introduced a pixel-based API for working with vector shapes.
This build extends the pixel-based API to pictures (file and memory), to charts, to visual components (vu-meters, google charts, geomaps, ...) and to text boxes.
With pixels, a floating 2D coordinate system is introduced. Obviously, pixels are converted internally in terms of columns, rows and offsets, so this is really for helping users write client applications. The 2D coordinate system has an origin in the top-left cell A1.
It makes it very easy for certain scenarios to add such objects to spreadsheets.
Here are the new method calls added to the xlsgen object model :
- NewPictureInPixels([in]BSTR filename, [in]int top, [in]int left, [in]int bottom, [in]int right);
- NewPictureInMemoryInPixels([in]VARIANT inputBytearray, [in]enumPictureType picType, [in]int top, [in]int left, [in]int bottom, [in]int right);
- NewChartInPixels([in]enumChartType type, [in]int top, [in]int left, [in]int bottom, [in]int right, [out, retval] IXlsChart** chart);
- NewVisualComponentInPixels([in]BSTR progId, [in]int top, [in]int left, [in]int bottom, [in]int right, [out, retval]IXlsVisualComponent** component);
- NewTextBoxInPixels([in]int top, [in]int left, [in]int bottom, [in]int right, [out, retval]IXlsTextBox** textbox);
Of course, the "old" (row,col,offset) API is still available.