dopatamil.blogg.se - Spreadsheet converter for open office calc

SPREADSHEET CONVERTER FOR OPEN OFFICE CALC CODE

Maybe there's a way to use ColorIndexes conversion from the ConstConvert class somehow.

I didn't do any experiments with border color parameter ( int color) in TableRange.BorderAround.

But this property is still valuable if you need to make all the columns as wide as a particular one after auto-sizing. The effect of double TableRange.ColumnWidth may vary from Excel to OOo, because I don't know what double means for both.Moves chart to the rectangle of the given TableRange (gets range's coordinates and uses DrawRect mutator). The FlushArray method transfers the data from the inner array, created with CreateArray, to the table processor. It's like with the usual array, which knows nothing about the range it will be placed to. Here indexes start from 0 and are relative to upper-left corner of the range. This enables your interaction with the array created. CreateArray, this, FlushArray:ĬreateArray creates an inner array of the range's size of the type, which can be directly understood by table processor ( uno.Any for OOo and object for Excel).Values, which are out of range, will be silently ignored. These values will be placed to the range's coordinates. You can place a single value or an array here. Note: Unlike Microsoft Excel, TablePage doesn't support the TableRange interface. TableRange - Represents a Range of Cells (Maybe One Cell)

SPREADSHEET CONVERTER FOR OPEN OFFICE CALC CODE

Again, cell indexes start from 1.Ĭopy Code AddDiagram(TableRange dataRange, RowsCols rowsCols, Gives you a TableRange object for the cell range you requested. Uses TableProcessor.CreateAvailable, but you get the TableSheet reference at once. Row indexes start from 1 (Excel style).Īdds an array you give it, starting at cell and increases the CurrentRow according to the array's height. The initial value (default is 1) is specified by the startRow parameter for TableProcessor.CreateNextPage or TableProcessor.CreateAvailable. You can use it for your own needs, but the common usage is for the AddArray method (see below). TableSheet - Represents a Single Table Processor PageĬan help you create reports row by row. Creates ExcelApp if Excel available, else creates OOApp (if OOo is available) or throws NoTableProcessorAvailableException if nothing was found.Īllow you to create the table processor you need directly. The startRow parameter is discussed below. For OOo, it looks like this query determines only if the whole OpenOffice is installed, but I can't find any better solution. Both methods are based on a registry query. These props should be used for determining if the desired table processor is installed. Abstract Interface TableProcessor - Used for an "Application Object" The INull interface and classes which implement it are designed to support the "Null object" pattern. I hope you've got the naming scheme and I have no need to draw the inheritance diagram.Īlso, there is a set of enums for constants, constant converter (my consts to Excel or OOo) and several support classes.

and similarly, 4 OpenOffice Calc classes:.

4 Excel classes, derived from abstract classes mentioned:.

Having experience working with Excel API should help you understand the code better. That's why the abstract table processor's interface is much like the Excel's one.

A good source of OpenOffice Calc samples for C#įor historical reasons, I started working with Excel and later I had to convert my projects to use both - OOo and Excel.

A tool which makes communication with OpenOffice Calc easier (even if you wouldn't use the Excel and abstract parts of the library).

Useful for creating simple reports (I use it myself for small business solutions).

You won't find a comprehensive solution for using both table processors here (some functionality is not implemented for OpenOffice and "cross-table-processor" interface is quite small too), but I believe that my library is: So I hope this article (and source code, of course) will make "cross-table processor" life for C# programmers a bit easier. And creating reports using different table processors (Excel and OOo Calc) separately is a bad habit and will be a source of errors in future. Using C# with Calc sometimes seems to be quite a problem.

OpenOffice 2.x is not supported anymore (but minor project changes should make it work).This is an updated version of the article and sources.