You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Avik Sengupta <av...@itellix.com> on 2004/07/08 15:49:42 UTC
POI in .NET
Have you yearned to use the wonders of POI in you .NET applications?
Well, then yearn no more. POI compiled into a .NET dll is available at
http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
The following C# code uses poi to create a new excel file.. it compiles
and runs successfully .. tested in mono, should be fine in windows as
well. Of course, no warranties, it may eat your homework :)
Done with IKVM. You need to download the IKVM runtime to run this.
Thoughts?
------------------------------------------------------------------
//Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
using System;
using org.apache.poi.hssf.usermodel;
using ikvm.lang;
class MainClass
{
public static void Main(string[] args)
{
Console.WriteLine("Hello World!");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s= wb.createSheet("Sheet1");
HSSFRow r= s.createRow(0);
HSSFCell c = r.createCell(1);
c.setCellValue(1);
java.io.FileOutputStream fs = new
java.io.FileOutputStream("dotnet.xls");
wb.write(fs);
fs.close();
}
}
-------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: POI in .NET
Posted by ac...@apache.org.
That=B9s the old floating point issue. The test should *round* the value
first. Floating point variables are only accurate to a point in any
langauge.. (haha)
--=20
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI
http://jakarta.apache.org/poi
For Java and Excel, Got POI?
The views expressed in this email are those of the author and are almost
definitely not shared by the Apache Software Foundation, its board or its
general membership. In fact they probably most definitively disagree with
everything espoused in the above email.
> From: Avik Sengupta <av...@itellix.com>
> Reply-To: "POI Developers List" <po...@jakarta.apache.org>
> Date: 14 Jul 2004 16:37:01 +0530
> To: poi-user@jakarta.apache.org
> Cc: poi-dev@jakarta.apache.org
> Subject: Re: POI in .NET
>=20
> I ran the POI tests on the 2.0-final version, and attached are the
> results. Most tests pass, and given the massive change in paradigm, i
> think this looks good. Will look at the one's that don't. To give you a
> flavour of why tests fail, the testFloat in TestFormulas fail with
> "1.5*5.1!=3D1.5*5.099999999999999".
>=20
> 2.5 however is another matter, coz all the drawing stuff makes heavy use
> of awt and J2D stuff, whose implementation in IKVM/Classpath is pretty
> weak.. not much should be expected in those areas in the near future.
>=20
> At some point, I will write all this up on the web, and if necessary ask
> the IKVM folks for help.
>=20
> [junit] Running org.apache.poi.hpsf.basic.TestBasic
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3.652
> sec
> [junit] Running org.apache.poi.hpsf.basic.TestClassID
> [junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.35 sec
> [junit] TEST org.apache.poi.hpsf.basic.TestClassID FAILED
> [junit] Running org.apache.poi.hpsf.basic.TestEmptyProperties
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.404
> sec
> [junit] Running org.apache.poi.hpsf.basic.TestUnicode
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.43 sec
> [junit] Running
> org.apache.poi.hssf.eventmodel.TestEventRecordFactory
> [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 2.535
> sec
> [junit] Running org.apache.poi.hssf.eventmodel.TestModelFactory
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.279
> sec
> [junit] Running org.apache.poi.hssf.model.TestFormulaParser
> [junit] Tests run: 22, Failures: 0, Errors: 0, Time elapsed: 4.917
> sec
> [junit] Running org.apache.poi.hssf.record.TestAreaFormatRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
> [junit] Running org.apache.poi.hssf.record.TestAreaRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.161
> sec
> [junit] Running org.apache.poi.hssf.record.TestAxisLineFormatRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
> sec
> [junit] Running org.apache.poi.hssf.record.TestAxisOptionsRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.194
> sec
> [junit] Running org.apache.poi.hssf.record.TestAxisParentRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
> sec
> [junit] Running org.apache.poi.hssf.record.TestAxisRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.47 sec
> [junit] Running org.apache.poi.hssf.record.TestAxisUsedRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.146
> sec
> [junit] Running org.apache.poi.hssf.record.TestBarRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.173
> sec
> [junit] Running org.apache.poi.hssf.record.TestBoundSheetRecord
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.136
> sec
> [junit] Running
> org.apache.poi.hssf.record.TestCategorySeriesAxisRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
> [junit] Running org.apache.poi.hssf.record.TestChartRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.157
> sec
> [junit] Running org.apache.poi.hssf.record.TestDatRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.171
> sec
> [junit] Running org.apache.poi.hssf.record.TestDataFormatRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.177
> sec
> [junit] Running
> org.apache.poi.hssf.record.TestDefaultDataLabelTextPropertiesRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.149
> sec
> [junit] Running org.apache.poi.hssf.record.TestFontBasisRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
> sec
> [junit] Running org.apache.poi.hssf.record.TestFontIndexRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.15 sec
> [junit] Running org.apache.poi.hssf.record.TestFormulaRecord
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.584
> sec
> [junit] Running org.apache.poi.hssf.record.TestFrameRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.205
> sec
> [junit] Running org.apache.poi.hssf.record.TestLegendRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.197
> sec
> [junit] Running org.apache.poi.hssf.record.TestLineFormatRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
> sec
> [junit] Running org.apache.poi.hssf.record.TestLinkedDataRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.45 sec
> [junit] Running org.apache.poi.hssf.record.TestMergeCellsRecord
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.132
> sec
> [junit] Running org.apache.poi.hssf.record.TestNameRecord
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.483
> sec
> [junit] Running
> org.apache.poi.hssf.record.TestNumberFormatIndexRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.151
> sec
> [junit] Running org.apache.poi.hssf.record.TestObjectLinkRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.155
> sec
> [junit] Running org.apache.poi.hssf.record.TestPaletteRecord
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.624
> sec
> [junit] Running org.apache.poi.hssf.record.TestPaneRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.165
> sec
> [junit] Running org.apache.poi.hssf.record.TestPlotAreaRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
> sec
> [junit] Running org.apache.poi.hssf.record.TestPlotGrowthRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
> sec
> [junit] Running org.apache.poi.hssf.record.TestRecordFactory
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2.955
> sec
> [junit] Running org.apache.poi.hssf.record.TestSCLRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
> sec
> [junit] Running org.apache.poi.hssf.record.TestSSTDeserializer
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.967
> sec
> [junit] Running org.apache.poi.hssf.record.TestSSTRecord
> [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 72.132
> sec
> [junit] Running
> org.apache.poi.hssf.record.TestSSTRecordSizeCalculator
> [junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.757
> sec
> [junit] Running
> org.apache.poi.hssf.record.TestSeriesChartGroupIndexRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
> sec
> [junit] Running org.apache.poi.hssf.record.TestSeriesIndexRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.134
> sec
> [junit] Running org.apache.poi.hssf.record.TestSeriesLabelsRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.162
> sec
> [junit] Running org.apache.poi.hssf.record.TestSeriesListRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.123
> sec
> [junit] Running org.apache.poi.hssf.record.TestSeriesRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
> sec
> [junit] Running org.apache.poi.hssf.record.TestSeriesTextRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.247
> sec
> [junit] Running
> org.apache.poi.hssf.record.TestSeriesToChartGroupRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.119
> sec
> [junit] Running org.apache.poi.hssf.record.TestSheetPropertiesRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.075
> sec
> [junit] Running org.apache.poi.hssf.record.TestStringRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.189
> sec
> [junit] Running org.apache.poi.hssf.record.TestSupBookRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
> sec
> [junit] Running org.apache.poi.hssf.record.TestTextRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.233
> sec
> [junit] Running org.apache.poi.hssf.record.TestTickRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
> sec
> [junit] Running org.apache.poi.hssf.record.TestUnitsRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.154
> sec
> [junit] Running org.apache.poi.hssf.record.TestValueRangeRecord
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
> sec
> [junit] Running
> org.apache.poi.hssf.record.aggregates.TestFormulaRecordAggregate
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.497
> sec
> [junit] Running
> org.apache.poi.hssf.record.aggregates.TestRowRecordsAggregate
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.144
> sec
> [junit] Running
> org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.257
> sec
> [junit] Running org.apache.poi.hssf.record.formula.TestFuncPtg
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.961
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestBugs
> [junit] Tests run: 21, Failures: 0, Errors: 0, Time elapsed: 257.003
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestCellStyle
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 8.102
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestCloneSheet
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 2.584
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestFormulas
> [junit] Tests run: 26, Failures: 1, Errors: 0, Time elapsed: 64.657
> sec
> [junit] TEST org.apache.poi.hssf.usermodel.TestFormulas FAILED
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFCell
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 7.145
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFDateUtil
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.405
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFHeaderFooter
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.508
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFPalette
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.76 sec
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFRow
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 7.075
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheet
> [junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 6.259
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetOrder
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.545
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetSetOrder
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.491
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestMisc
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.08 sec
> [junit] Running org.apache.poi.hssf.usermodel.TestNamedRange
> [junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 7.856
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestReadWriteChart
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 5.255
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestSanityChecker
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.573
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestSheetShiftRows
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.612
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestTemp
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.089
> sec
> [junit] Running org.apache.poi.hssf.usermodel.TestWorkbook
> [junit] Tests run: 16, Failures: 0, Errors: 0, Time elapsed: 39.247
> sec
> [junit] Running org.apache.poi.hssf.util.TestAreaReference
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.143
> sec
> [junit] Running org.apache.poi.hssf.util.TestCellReference
> [junit] Tests run: 8, Failures: 0, Errors: 0, Time elapsed: 0.133
> sec
> [junit] Running org.apache.poi.hssf.util.TestRKUtil
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.085
> sec
> [junit] Running org.apache.poi.hssf.util.TestRangeAddress
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.155
> sec
> [junit] Running org.apache.poi.hssf.util.TestSheetReferences
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.093
> sec
> [junit] Running
> org.apache.poi.poifs.eventfilesystem.TestPOIFSReaderRegistry
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.245
> sec
> [junit] Running org.apache.poi.poifs.filesystem.TestDirectoryNode
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 1.052
> sec
> [junit] Running org.apache.poi.poifs.filesystem.TestDocument
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 60.833
> sec
> [junit] Running
> org.apache.poi.poifs.filesystem.TestDocumentDescriptor
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.191
> sec
> [junit] Running
> org.apache.poi.poifs.filesystem.TestDocumentInputStream
> [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 103.291
> sec
> [junit] Running org.apache.poi.poifs.filesystem.TestDocumentNode
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.568
> sec
> [junit] Running
> org.apache.poi.poifs.filesystem.TestDocumentOutputStream
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.092
> sec
> [junit] Running
> org.apache.poi.poifs.filesystem.TestPOIFSDocumentPath
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.109
> sec
> [junit] Running org.apache.poi.poifs.property.TestDirectoryProperty
> [junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 2.378
> sec
> [junit] Running org.apache.poi.poifs.property.TestDocumentProperty
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.29 sec
> [junit] Running org.apache.poi.poifs.property.TestPropertyFactory
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.735
> sec
> [junit] Running org.apache.poi.poifs.property.TestPropertyTable
> [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.996
> sec
> [junit] Running org.apache.poi.poifs.property.TestRootProperty
> [junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.383
> sec
> [junit] TEST org.apache.poi.poifs.property.TestRootProperty FAILED
> [junit] Running org.apache.poi.poifs.storage.TestBATBlock
> [junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.204
> sec
> [junit] Running
> org.apache.poi.poifs.storage.TestBlockAllocationTableReader
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.968
> sec
> [junit] Running
> org.apache.poi.poifs.storage.TestBlockAllocationTableWriter
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.284
> sec
> [junit] Running org.apache.poi.poifs.storage.TestBlockListImpl
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.388
> sec
> [junit] Running org.apache.poi.poifs.storage.TestDocumentBlock
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.084
> sec
> [junit] Running org.apache.poi.poifs.storage.TestHeaderBlockReader
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.204
> sec
> [junit] Running org.apache.poi.poifs.storage.TestHeaderBlockWriter
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.317
> sec
> [junit] Running org.apache.poi.poifs.storage.TestPropertyBlock
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.298
> sec
> [junit] Running org.apache.poi.poifs.storage.TestRawDataBlock
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.175
> sec
> [junit] Running org.apache.poi.poifs.storage.TestRawDataBlockList
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.306
> sec
> [junit] Running
> org.apache.poi.poifs.storage.TestSmallBlockTableReader
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.795
> sec
> [junit] Running
> org.apache.poi.poifs.storage.TestSmallBlockTableWriter
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.638
> sec
> [junit] Running org.apache.poi.poifs.storage.TestSmallDocumentBlock
> [junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 9.562
> sec
> [junit] Running
> org.apache.poi.poifs.storage.TestSmallDocumentBlockList
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.099
> sec
> [junit] Running org.apache.poi.util.TestBinaryTree
> [junit] Tests run: 20, Failures: 7, Errors: 6, Time elapsed: 3.555
> sec
> [junit] TEST org.apache.poi.util.TestBinaryTree FAILED
> [junit] Running org.apache.poi.util.TestBitField
> [junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.074
> sec
> [junit] Running org.apache.poi.util.TestByteField
> [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.118
> sec
> [junit] Running org.apache.poi.util.TestHexDump
> [junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 0.199
> sec
> [junit] TEST org.apache.poi.util.TestHexDump FAILED
> [junit] Running org.apache.poi.util.TestIntList
> [junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.169
> sec
> [junit] TEST org.apache.poi.util.TestIntList FAILED
> [junit] Running org.apache.poi.util.TestIntegerField
> [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.128
> sec
> [junit] Running org.apache.poi.util.TestLittleEndian
> [junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.11
> sec
> [junit] Running org.apache.poi.util.TestLongField
> [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 1.827
> sec
> [junit] Running org.apache.poi.util.TestPOILogFactory
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.146
> sec
> [junit] Running org.apache.poi.util.TestPOILogger
> [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.153
> sec
> [junit] Running org.apache.poi.util.TestShortField
> [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.119
> sec
> [junit] Running org.apache.poi.util.TestShortList
> [junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.195
> sec
> [junit] TEST org.apache.poi.util.TestShortList FAILED
> [junit] Running org.apache.poi.util.TestStringUtil
> [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 0.173
> sec
>=20
>=20
> On Thu, 2004-07-08 at 19:19, Avik Sengupta wrote:
>> Have you yearned to use the wonders of POI in you .NET applications?
>> Well, then yearn no more. POI compiled into a .NET dll is available at
>>=20
>> http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
>>=20
>> The following C# code uses poi to create a new excel file.. it compiles
>> and runs successfully .. tested in mono, should be fine in windows as
>> well. Of course, no warranties, it may eat your homework :)
>>=20
>> Done with IKVM. You need to download the IKVM runtime to run this.
>>=20
>> Thoughts?=20
>>=20
>> ------------------------------------------------------------------
>> //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
>> using System;
>> using org.apache.poi.hssf.usermodel;
>> using ikvm.lang;
>>=20
>> class MainClass
>> {
>> public static void Main(string[] args)
>> {
>> Console.WriteLine("Hello World!");
>> HSSFWorkbook wb =3D new HSSFWorkbook();
>> HSSFSheet s=3D wb.createSheet("Sheet1");
>> HSSFRow r=3D s.createRow(0);
>> HSSFCell c =3D r.createCell(1);
>> c.setCellValue(1);
>> java.io.FileOutputStream fs =3D new
>> java.io.FileOutputStream("dotnet.xls");
>> wb.write(fs);
>> fs.close();
>> }
>> }
>> -------------------------------------------------------------------
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
Re: POI in .NET
Posted by Avik Sengupta <av...@itellix.com>.
I ran the POI tests on the 2.0-final version, and attached are the
results. Most tests pass, and given the massive change in paradigm, i
think this looks good. Will look at the one's that don't. To give you a
flavour of why tests fail, the testFloat in TestFormulas fail with
"1.5*5.1!=1.5*5.099999999999999".
2.5 however is another matter, coz all the drawing stuff makes heavy use
of awt and J2D stuff, whose implementation in IKVM/Classpath is pretty
weak.. not much should be expected in those areas in the near future.
At some point, I will write all this up on the web, and if necessary ask
the IKVM folks for help.
[junit] Running org.apache.poi.hpsf.basic.TestBasic
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3.652
sec
[junit] Running org.apache.poi.hpsf.basic.TestClassID
[junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.35 sec
[junit] TEST org.apache.poi.hpsf.basic.TestClassID FAILED
[junit] Running org.apache.poi.hpsf.basic.TestEmptyProperties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.404
sec
[junit] Running org.apache.poi.hpsf.basic.TestUnicode
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.43 sec
[junit] Running
org.apache.poi.hssf.eventmodel.TestEventRecordFactory
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 2.535
sec
[junit] Running org.apache.poi.hssf.eventmodel.TestModelFactory
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.279
sec
[junit] Running org.apache.poi.hssf.model.TestFormulaParser
[junit] Tests run: 22, Failures: 0, Errors: 0, Time elapsed: 4.917
sec
[junit] Running org.apache.poi.hssf.record.TestAreaFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
[junit] Running org.apache.poi.hssf.record.TestAreaRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.161
sec
[junit] Running org.apache.poi.hssf.record.TestAxisLineFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
sec
[junit] Running org.apache.poi.hssf.record.TestAxisOptionsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.194
sec
[junit] Running org.apache.poi.hssf.record.TestAxisParentRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestAxisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.47 sec
[junit] Running org.apache.poi.hssf.record.TestAxisUsedRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.146
sec
[junit] Running org.apache.poi.hssf.record.TestBarRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.173
sec
[junit] Running org.apache.poi.hssf.record.TestBoundSheetRecord
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.136
sec
[junit] Running
org.apache.poi.hssf.record.TestCategorySeriesAxisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
[junit] Running org.apache.poi.hssf.record.TestChartRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.157
sec
[junit] Running org.apache.poi.hssf.record.TestDatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.171
sec
[junit] Running org.apache.poi.hssf.record.TestDataFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.177
sec
[junit] Running
org.apache.poi.hssf.record.TestDefaultDataLabelTextPropertiesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.149
sec
[junit] Running org.apache.poi.hssf.record.TestFontBasisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
sec
[junit] Running org.apache.poi.hssf.record.TestFontIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.15 sec
[junit] Running org.apache.poi.hssf.record.TestFormulaRecord
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.584
sec
[junit] Running org.apache.poi.hssf.record.TestFrameRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.205
sec
[junit] Running org.apache.poi.hssf.record.TestLegendRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.197
sec
[junit] Running org.apache.poi.hssf.record.TestLineFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
sec
[junit] Running org.apache.poi.hssf.record.TestLinkedDataRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.45 sec
[junit] Running org.apache.poi.hssf.record.TestMergeCellsRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.132
sec
[junit] Running org.apache.poi.hssf.record.TestNameRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.483
sec
[junit] Running
org.apache.poi.hssf.record.TestNumberFormatIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.151
sec
[junit] Running org.apache.poi.hssf.record.TestObjectLinkRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.155
sec
[junit] Running org.apache.poi.hssf.record.TestPaletteRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.624
sec
[junit] Running org.apache.poi.hssf.record.TestPaneRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.165
sec
[junit] Running org.apache.poi.hssf.record.TestPlotAreaRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
sec
[junit] Running org.apache.poi.hssf.record.TestPlotGrowthRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestRecordFactory
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2.955
sec
[junit] Running org.apache.poi.hssf.record.TestSCLRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestSSTDeserializer
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.967
sec
[junit] Running org.apache.poi.hssf.record.TestSSTRecord
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 72.132
sec
[junit] Running
org.apache.poi.hssf.record.TestSSTRecordSizeCalculator
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.757
sec
[junit] Running
org.apache.poi.hssf.record.TestSeriesChartGroupIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.134
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesLabelsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.162
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesListRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.123
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesTextRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.247
sec
[junit] Running
org.apache.poi.hssf.record.TestSeriesToChartGroupRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.119
sec
[junit] Running org.apache.poi.hssf.record.TestSheetPropertiesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.075
sec
[junit] Running org.apache.poi.hssf.record.TestStringRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.189
sec
[junit] Running org.apache.poi.hssf.record.TestSupBookRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
sec
[junit] Running org.apache.poi.hssf.record.TestTextRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.233
sec
[junit] Running org.apache.poi.hssf.record.TestTickRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
sec
[junit] Running org.apache.poi.hssf.record.TestUnitsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.154
sec
[junit] Running org.apache.poi.hssf.record.TestValueRangeRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestFormulaRecordAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.497
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestRowRecordsAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.144
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.257
sec
[junit] Running org.apache.poi.hssf.record.formula.TestFuncPtg
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.961
sec
[junit] Running org.apache.poi.hssf.usermodel.TestBugs
[junit] Tests run: 21, Failures: 0, Errors: 0, Time elapsed: 257.003
sec
[junit] Running org.apache.poi.hssf.usermodel.TestCellStyle
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 8.102
sec
[junit] Running org.apache.poi.hssf.usermodel.TestCloneSheet
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 2.584
sec
[junit] Running org.apache.poi.hssf.usermodel.TestFormulas
[junit] Tests run: 26, Failures: 1, Errors: 0, Time elapsed: 64.657
sec
[junit] TEST org.apache.poi.hssf.usermodel.TestFormulas FAILED
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFCell
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 7.145
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFDateUtil
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.405
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFHeaderFooter
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.508
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFPalette
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.76 sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFRow
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 7.075
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheet
[junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 6.259
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetOrder
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.545
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetSetOrder
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.491
sec
[junit] Running org.apache.poi.hssf.usermodel.TestMisc
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.08 sec
[junit] Running org.apache.poi.hssf.usermodel.TestNamedRange
[junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 7.856
sec
[junit] Running org.apache.poi.hssf.usermodel.TestReadWriteChart
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 5.255
sec
[junit] Running org.apache.poi.hssf.usermodel.TestSanityChecker
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.573
sec
[junit] Running org.apache.poi.hssf.usermodel.TestSheetShiftRows
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.612
sec
[junit] Running org.apache.poi.hssf.usermodel.TestTemp
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.089
sec
[junit] Running org.apache.poi.hssf.usermodel.TestWorkbook
[junit] Tests run: 16, Failures: 0, Errors: 0, Time elapsed: 39.247
sec
[junit] Running org.apache.poi.hssf.util.TestAreaReference
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.143
sec
[junit] Running org.apache.poi.hssf.util.TestCellReference
[junit] Tests run: 8, Failures: 0, Errors: 0, Time elapsed: 0.133
sec
[junit] Running org.apache.poi.hssf.util.TestRKUtil
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.085
sec
[junit] Running org.apache.poi.hssf.util.TestRangeAddress
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.155
sec
[junit] Running org.apache.poi.hssf.util.TestSheetReferences
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.093
sec
[junit] Running
org.apache.poi.poifs.eventfilesystem.TestPOIFSReaderRegistry
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.245
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDirectoryNode
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 1.052
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDocument
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 60.833
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentDescriptor
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.191
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentInputStream
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 103.291
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDocumentNode
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.568
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentOutputStream
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.092
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestPOIFSDocumentPath
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.109
sec
[junit] Running org.apache.poi.poifs.property.TestDirectoryProperty
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 2.378
sec
[junit] Running org.apache.poi.poifs.property.TestDocumentProperty
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.29 sec
[junit] Running org.apache.poi.poifs.property.TestPropertyFactory
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.735
sec
[junit] Running org.apache.poi.poifs.property.TestPropertyTable
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.996
sec
[junit] Running org.apache.poi.poifs.property.TestRootProperty
[junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.383
sec
[junit] TEST org.apache.poi.poifs.property.TestRootProperty FAILED
[junit] Running org.apache.poi.poifs.storage.TestBATBlock
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.204
sec
[junit] Running
org.apache.poi.poifs.storage.TestBlockAllocationTableReader
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.968
sec
[junit] Running
org.apache.poi.poifs.storage.TestBlockAllocationTableWriter
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.284
sec
[junit] Running org.apache.poi.poifs.storage.TestBlockListImpl
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.388
sec
[junit] Running org.apache.poi.poifs.storage.TestDocumentBlock
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.084
sec
[junit] Running org.apache.poi.poifs.storage.TestHeaderBlockReader
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.204
sec
[junit] Running org.apache.poi.poifs.storage.TestHeaderBlockWriter
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.317
sec
[junit] Running org.apache.poi.poifs.storage.TestPropertyBlock
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.298
sec
[junit] Running org.apache.poi.poifs.storage.TestRawDataBlock
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.175
sec
[junit] Running org.apache.poi.poifs.storage.TestRawDataBlockList
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.306
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallBlockTableReader
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.795
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallBlockTableWriter
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.638
sec
[junit] Running org.apache.poi.poifs.storage.TestSmallDocumentBlock
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 9.562
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallDocumentBlockList
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.099
sec
[junit] Running org.apache.poi.util.TestBinaryTree
[junit] Tests run: 20, Failures: 7, Errors: 6, Time elapsed: 3.555
sec
[junit] TEST org.apache.poi.util.TestBinaryTree FAILED
[junit] Running org.apache.poi.util.TestBitField
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.074
sec
[junit] Running org.apache.poi.util.TestByteField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.118
sec
[junit] Running org.apache.poi.util.TestHexDump
[junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 0.199
sec
[junit] TEST org.apache.poi.util.TestHexDump FAILED
[junit] Running org.apache.poi.util.TestIntList
[junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.169
sec
[junit] TEST org.apache.poi.util.TestIntList FAILED
[junit] Running org.apache.poi.util.TestIntegerField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.128
sec
[junit] Running org.apache.poi.util.TestLittleEndian
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.11
sec
[junit] Running org.apache.poi.util.TestLongField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 1.827
sec
[junit] Running org.apache.poi.util.TestPOILogFactory
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.146
sec
[junit] Running org.apache.poi.util.TestPOILogger
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.153
sec
[junit] Running org.apache.poi.util.TestShortField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.119
sec
[junit] Running org.apache.poi.util.TestShortList
[junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.195
sec
[junit] TEST org.apache.poi.util.TestShortList FAILED
[junit] Running org.apache.poi.util.TestStringUtil
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 0.173
sec
On Thu, 2004-07-08 at 19:19, Avik Sengupta wrote:
> Have you yearned to use the wonders of POI in you .NET applications?
> Well, then yearn no more. POI compiled into a .NET dll is available at
>
> http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
>
> The following C# code uses poi to create a new excel file.. it compiles
> and runs successfully .. tested in mono, should be fine in windows as
> well. Of course, no warranties, it may eat your homework :)
>
> Done with IKVM. You need to download the IKVM runtime to run this.
>
> Thoughts?
>
> ------------------------------------------------------------------
> //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
> using System;
> using org.apache.poi.hssf.usermodel;
> using ikvm.lang;
>
> class MainClass
> {
> public static void Main(string[] args)
> {
> Console.WriteLine("Hello World!");
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet s= wb.createSheet("Sheet1");
> HSSFRow r= s.createRow(0);
> HSSFCell c = r.createCell(1);
> c.setCellValue(1);
> java.io.FileOutputStream fs = new
> java.io.FileOutputStream("dotnet.xls");
> wb.write(fs);
> fs.close();
> }
> }
> -------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
Re: POI in .NET
Posted by Avik Sengupta <av...@itellix.com>.
As I said, its cool... have you seen people running eclipse inside IKVM
inside mono? Its totally cool and totally useless ..
But if you wanted to, you could provide reasons like
1. Office COM components are not recommended to be used server side.
(Michael Veit just sent a mail with much more info on this)
2. If you have a client side C# app, want to generate excel in that app,
but cant (or don't want to) ensure that each desktop has office
installed (and paid for!)
Regards
-
Avik
On Thu, 2004-07-08 at 19:39, wolfgang unger wrote:
> Cool, but:
> I don't understand the sense...
> It is very much easier accessing Office with VB, C++ (C# ?)and OLE.
> Why should I want to use the complex Poi stuff, when
> I can do it so simple like in VB without POI?
> I thought the only reason using POI isJava...
>
> Greetings wolfgang
>
> > Have you yearned to use the wonders of POI in you .NET applications?
> > Well, then yearn no more. POI compiled into a .NET dll is available at
> >
> > http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
> >
> > The following C# code uses poi to create a new excel file.. it compiles
> > and runs successfully .. tested in mono, should be fine in windows as
> > well. Of course, no warranties, it may eat your homework :)
> >
> > Done with IKVM. You need to download the IKVM runtime to run this.
> >
> > Thoughts?
> >
> > ------------------------------------------------------------------
> > //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
> > using System;
> > using org.apache.poi.hssf.usermodel;
> > using ikvm.lang;
> >
> > class MainClass
> > {
> > public static void Main(string[] args)
> > {
> > Console.WriteLine("Hello World!");
> > HSSFWorkbook wb = new HSSFWorkbook();
> > HSSFSheet s= wb.createSheet("Sheet1");
> > HSSFRow r= s.createRow(0);
> > HSSFCell c = r.createCell(1);
> > c.setCellValue(1);
> > java.io.FileOutputStream fs = new
> > java.io.FileOutputStream("dotnet.xls");
> > wb.write(fs);
> > fs.close();
> > }
> > }
> > -------------------------------------------------------------------
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: POI in .NET
Posted by wolfgang unger <wo...@gmx.de>.
Cool, but:
I don't understand the sense...
It is very much easier accessing Office with VB, C++ (C# ?)and OLE.
Why should I want to use the complex Poi stuff, when
I can do it so simple like in VB without POI?
I thought the only reason using POI isJava...
Greetings wolfgang
> Have you yearned to use the wonders of POI in you .NET applications?
> Well, then yearn no more. POI compiled into a .NET dll is available at
>
> http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
>
> The following C# code uses poi to create a new excel file.. it compiles
> and runs successfully .. tested in mono, should be fine in windows as
> well. Of course, no warranties, it may eat your homework :)
>
> Done with IKVM. You need to download the IKVM runtime to run this.
>
> Thoughts?
>
> ------------------------------------------------------------------
> //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
> using System;
> using org.apache.poi.hssf.usermodel;
> using ikvm.lang;
>
> class MainClass
> {
> public static void Main(string[] args)
> {
> Console.WriteLine("Hello World!");
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet s= wb.createSheet("Sheet1");
> HSSFRow r= s.createRow(0);
> HSSFCell c = r.createCell(1);
> c.setCellValue(1);
> java.io.FileOutputStream fs = new
> java.io.FileOutputStream("dotnet.xls");
> wb.write(fs);
> fs.close();
> }
> }
> -------------------------------------------------------------------
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
--
+++ Jetzt WLAN-Router f�r alle DSL-Einsteiger und Wechsler +++
GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: POI in .NET
Posted by Avik Sengupta <av...@itellix.com>.
I ran the POI tests on the 2.0-final version, and attached are the
results. Most tests pass, and given the massive change in paradigm, i
think this looks good. Will look at the one's that don't. To give you a
flavour of why tests fail, the testFloat in TestFormulas fail with
"1.5*5.1!=1.5*5.099999999999999".
2.5 however is another matter, coz all the drawing stuff makes heavy use
of awt and J2D stuff, whose implementation in IKVM/Classpath is pretty
weak.. not much should be expected in those areas in the near future.
At some point, I will write all this up on the web, and if necessary ask
the IKVM folks for help.
[junit] Running org.apache.poi.hpsf.basic.TestBasic
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3.652
sec
[junit] Running org.apache.poi.hpsf.basic.TestClassID
[junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.35 sec
[junit] TEST org.apache.poi.hpsf.basic.TestClassID FAILED
[junit] Running org.apache.poi.hpsf.basic.TestEmptyProperties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.404
sec
[junit] Running org.apache.poi.hpsf.basic.TestUnicode
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.43 sec
[junit] Running
org.apache.poi.hssf.eventmodel.TestEventRecordFactory
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 2.535
sec
[junit] Running org.apache.poi.hssf.eventmodel.TestModelFactory
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.279
sec
[junit] Running org.apache.poi.hssf.model.TestFormulaParser
[junit] Tests run: 22, Failures: 0, Errors: 0, Time elapsed: 4.917
sec
[junit] Running org.apache.poi.hssf.record.TestAreaFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
[junit] Running org.apache.poi.hssf.record.TestAreaRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.161
sec
[junit] Running org.apache.poi.hssf.record.TestAxisLineFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
sec
[junit] Running org.apache.poi.hssf.record.TestAxisOptionsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.194
sec
[junit] Running org.apache.poi.hssf.record.TestAxisParentRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestAxisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.47 sec
[junit] Running org.apache.poi.hssf.record.TestAxisUsedRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.146
sec
[junit] Running org.apache.poi.hssf.record.TestBarRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.173
sec
[junit] Running org.apache.poi.hssf.record.TestBoundSheetRecord
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.136
sec
[junit] Running
org.apache.poi.hssf.record.TestCategorySeriesAxisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
[junit] Running org.apache.poi.hssf.record.TestChartRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.157
sec
[junit] Running org.apache.poi.hssf.record.TestDatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.171
sec
[junit] Running org.apache.poi.hssf.record.TestDataFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.177
sec
[junit] Running
org.apache.poi.hssf.record.TestDefaultDataLabelTextPropertiesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.149
sec
[junit] Running org.apache.poi.hssf.record.TestFontBasisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
sec
[junit] Running org.apache.poi.hssf.record.TestFontIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.15 sec
[junit] Running org.apache.poi.hssf.record.TestFormulaRecord
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.584
sec
[junit] Running org.apache.poi.hssf.record.TestFrameRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.205
sec
[junit] Running org.apache.poi.hssf.record.TestLegendRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.197
sec
[junit] Running org.apache.poi.hssf.record.TestLineFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
sec
[junit] Running org.apache.poi.hssf.record.TestLinkedDataRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.45 sec
[junit] Running org.apache.poi.hssf.record.TestMergeCellsRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.132
sec
[junit] Running org.apache.poi.hssf.record.TestNameRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.483
sec
[junit] Running
org.apache.poi.hssf.record.TestNumberFormatIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.151
sec
[junit] Running org.apache.poi.hssf.record.TestObjectLinkRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.155
sec
[junit] Running org.apache.poi.hssf.record.TestPaletteRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.624
sec
[junit] Running org.apache.poi.hssf.record.TestPaneRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.165
sec
[junit] Running org.apache.poi.hssf.record.TestPlotAreaRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
sec
[junit] Running org.apache.poi.hssf.record.TestPlotGrowthRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestRecordFactory
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2.955
sec
[junit] Running org.apache.poi.hssf.record.TestSCLRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestSSTDeserializer
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.967
sec
[junit] Running org.apache.poi.hssf.record.TestSSTRecord
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 72.132
sec
[junit] Running
org.apache.poi.hssf.record.TestSSTRecordSizeCalculator
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.757
sec
[junit] Running
org.apache.poi.hssf.record.TestSeriesChartGroupIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.134
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesLabelsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.162
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesListRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.123
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesTextRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.247
sec
[junit] Running
org.apache.poi.hssf.record.TestSeriesToChartGroupRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.119
sec
[junit] Running org.apache.poi.hssf.record.TestSheetPropertiesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.075
sec
[junit] Running org.apache.poi.hssf.record.TestStringRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.189
sec
[junit] Running org.apache.poi.hssf.record.TestSupBookRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
sec
[junit] Running org.apache.poi.hssf.record.TestTextRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.233
sec
[junit] Running org.apache.poi.hssf.record.TestTickRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
sec
[junit] Running org.apache.poi.hssf.record.TestUnitsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.154
sec
[junit] Running org.apache.poi.hssf.record.TestValueRangeRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestFormulaRecordAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.497
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestRowRecordsAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.144
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.257
sec
[junit] Running org.apache.poi.hssf.record.formula.TestFuncPtg
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.961
sec
[junit] Running org.apache.poi.hssf.usermodel.TestBugs
[junit] Tests run: 21, Failures: 0, Errors: 0, Time elapsed: 257.003
sec
[junit] Running org.apache.poi.hssf.usermodel.TestCellStyle
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 8.102
sec
[junit] Running org.apache.poi.hssf.usermodel.TestCloneSheet
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 2.584
sec
[junit] Running org.apache.poi.hssf.usermodel.TestFormulas
[junit] Tests run: 26, Failures: 1, Errors: 0, Time elapsed: 64.657
sec
[junit] TEST org.apache.poi.hssf.usermodel.TestFormulas FAILED
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFCell
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 7.145
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFDateUtil
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.405
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFHeaderFooter
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.508
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFPalette
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.76 sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFRow
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 7.075
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheet
[junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 6.259
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetOrder
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.545
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetSetOrder
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.491
sec
[junit] Running org.apache.poi.hssf.usermodel.TestMisc
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.08 sec
[junit] Running org.apache.poi.hssf.usermodel.TestNamedRange
[junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 7.856
sec
[junit] Running org.apache.poi.hssf.usermodel.TestReadWriteChart
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 5.255
sec
[junit] Running org.apache.poi.hssf.usermodel.TestSanityChecker
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.573
sec
[junit] Running org.apache.poi.hssf.usermodel.TestSheetShiftRows
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.612
sec
[junit] Running org.apache.poi.hssf.usermodel.TestTemp
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.089
sec
[junit] Running org.apache.poi.hssf.usermodel.TestWorkbook
[junit] Tests run: 16, Failures: 0, Errors: 0, Time elapsed: 39.247
sec
[junit] Running org.apache.poi.hssf.util.TestAreaReference
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.143
sec
[junit] Running org.apache.poi.hssf.util.TestCellReference
[junit] Tests run: 8, Failures: 0, Errors: 0, Time elapsed: 0.133
sec
[junit] Running org.apache.poi.hssf.util.TestRKUtil
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.085
sec
[junit] Running org.apache.poi.hssf.util.TestRangeAddress
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.155
sec
[junit] Running org.apache.poi.hssf.util.TestSheetReferences
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.093
sec
[junit] Running
org.apache.poi.poifs.eventfilesystem.TestPOIFSReaderRegistry
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.245
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDirectoryNode
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 1.052
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDocument
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 60.833
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentDescriptor
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.191
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentInputStream
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 103.291
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDocumentNode
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.568
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentOutputStream
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.092
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestPOIFSDocumentPath
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.109
sec
[junit] Running org.apache.poi.poifs.property.TestDirectoryProperty
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 2.378
sec
[junit] Running org.apache.poi.poifs.property.TestDocumentProperty
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.29 sec
[junit] Running org.apache.poi.poifs.property.TestPropertyFactory
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.735
sec
[junit] Running org.apache.poi.poifs.property.TestPropertyTable
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.996
sec
[junit] Running org.apache.poi.poifs.property.TestRootProperty
[junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.383
sec
[junit] TEST org.apache.poi.poifs.property.TestRootProperty FAILED
[junit] Running org.apache.poi.poifs.storage.TestBATBlock
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.204
sec
[junit] Running
org.apache.poi.poifs.storage.TestBlockAllocationTableReader
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.968
sec
[junit] Running
org.apache.poi.poifs.storage.TestBlockAllocationTableWriter
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.284
sec
[junit] Running org.apache.poi.poifs.storage.TestBlockListImpl
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.388
sec
[junit] Running org.apache.poi.poifs.storage.TestDocumentBlock
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.084
sec
[junit] Running org.apache.poi.poifs.storage.TestHeaderBlockReader
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.204
sec
[junit] Running org.apache.poi.poifs.storage.TestHeaderBlockWriter
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.317
sec
[junit] Running org.apache.poi.poifs.storage.TestPropertyBlock
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.298
sec
[junit] Running org.apache.poi.poifs.storage.TestRawDataBlock
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.175
sec
[junit] Running org.apache.poi.poifs.storage.TestRawDataBlockList
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.306
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallBlockTableReader
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.795
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallBlockTableWriter
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.638
sec
[junit] Running org.apache.poi.poifs.storage.TestSmallDocumentBlock
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 9.562
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallDocumentBlockList
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.099
sec
[junit] Running org.apache.poi.util.TestBinaryTree
[junit] Tests run: 20, Failures: 7, Errors: 6, Time elapsed: 3.555
sec
[junit] TEST org.apache.poi.util.TestBinaryTree FAILED
[junit] Running org.apache.poi.util.TestBitField
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.074
sec
[junit] Running org.apache.poi.util.TestByteField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.118
sec
[junit] Running org.apache.poi.util.TestHexDump
[junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 0.199
sec
[junit] TEST org.apache.poi.util.TestHexDump FAILED
[junit] Running org.apache.poi.util.TestIntList
[junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.169
sec
[junit] TEST org.apache.poi.util.TestIntList FAILED
[junit] Running org.apache.poi.util.TestIntegerField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.128
sec
[junit] Running org.apache.poi.util.TestLittleEndian
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.11
sec
[junit] Running org.apache.poi.util.TestLongField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 1.827
sec
[junit] Running org.apache.poi.util.TestPOILogFactory
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.146
sec
[junit] Running org.apache.poi.util.TestPOILogger
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.153
sec
[junit] Running org.apache.poi.util.TestShortField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.119
sec
[junit] Running org.apache.poi.util.TestShortList
[junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.195
sec
[junit] TEST org.apache.poi.util.TestShortList FAILED
[junit] Running org.apache.poi.util.TestStringUtil
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 0.173
sec
On Thu, 2004-07-08 at 19:19, Avik Sengupta wrote:
> Have you yearned to use the wonders of POI in you .NET applications?
> Well, then yearn no more. POI compiled into a .NET dll is available at
>
> http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
>
> The following C# code uses poi to create a new excel file.. it compiles
> and runs successfully .. tested in mono, should be fine in windows as
> well. Of course, no warranties, it may eat your homework :)
>
> Done with IKVM. You need to download the IKVM runtime to run this.
>
> Thoughts?
>
> ------------------------------------------------------------------
> //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
> using System;
> using org.apache.poi.hssf.usermodel;
> using ikvm.lang;
>
> class MainClass
> {
> public static void Main(string[] args)
> {
> Console.WriteLine("Hello World!");
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet s= wb.createSheet("Sheet1");
> HSSFRow r= s.createRow(0);
> HSSFCell c = r.createCell(1);
> c.setCellValue(1);
> java.io.FileOutputStream fs = new
> java.io.FileOutputStream("dotnet.xls");
> wb.write(fs);
> fs.close();
> }
> }
> -------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
RE: POI in .NET
Posted by Avik Sengupta <av...@itellix.com>.
Oh, I did it only for the coolness factor ..:) don't know actually how
useful this will be, so looking for feedback ...
Its the latest CVS on REL_2_BRANCH, so it doesn't have the latest word
code, which is in 'contrib' on HEAD. If there is some interest, I'll
generate it.
Regards
-
Avik
On Thu, 2004-07-08 at 19:31, Kais Dukes wrote:
> Hi Avik
>
> That’s really cool.
>
> Is this just HSSF, or Word as well??
>
> Kind Regards,
>
> Kais
>
> -----Original Message-----
> From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
> Sent: 08 July 2004 14:50
> To: poi-user@jakarta.apache.org
> Cc: poi-dev@jakarta.apache.org
> Subject: POI in .NET
>
> Have you yearned to use the wonders of POI in you .NET applications?
> Well, then yearn no more. POI compiled into a .NET dll is available at
>
> http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
>
> The following C# code uses poi to create a new excel file.. it compiles
> and runs successfully .. tested in mono, should be fine in windows as
> well. Of course, no warranties, it may eat your homework :)
>
> Done with IKVM. You need to download the IKVM runtime to run this.
>
> Thoughts?
>
> ------------------------------------------------------------------
> //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
> using System;
> using org.apache.poi.hssf.usermodel;
> using ikvm.lang;
>
> class MainClass
> {
> public static void Main(string[] args)
> {
> Console.WriteLine("Hello World!");
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet s= wb.createSheet("Sheet1");
> HSSFRow r= s.createRow(0);
> HSSFCell c = r.createCell(1);
> c.setCellValue(1);
> java.io.FileOutputStream fs = new
> java.io.FileOutputStream("dotnet.xls");
> wb.write(fs);
> fs.close();
> }
> }
> -------------------------------------------------------------------
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
RE: POI in .NET
Posted by Avik Sengupta <av...@itellix.com>.
Oh, I did it only for the coolness factor ..:) don't know actually how
useful this will be, so looking for feedback ...
Its the latest CVS on REL_2_BRANCH, so it doesn't have the latest word
code, which is in 'contrib' on HEAD. If there is some interest, I'll
generate it.
Regards
-
Avik
On Thu, 2004-07-08 at 19:31, Kais Dukes wrote:
> Hi Avik
>
> That’s really cool.
>
> Is this just HSSF, or Word as well??
>
> Kind Regards,
>
> Kais
>
> -----Original Message-----
> From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
> Sent: 08 July 2004 14:50
> To: poi-user@jakarta.apache.org
> Cc: poi-dev@jakarta.apache.org
> Subject: POI in .NET
>
> Have you yearned to use the wonders of POI in you .NET applications?
> Well, then yearn no more. POI compiled into a .NET dll is available at
>
> http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
>
> The following C# code uses poi to create a new excel file.. it compiles
> and runs successfully .. tested in mono, should be fine in windows as
> well. Of course, no warranties, it may eat your homework :)
>
> Done with IKVM. You need to download the IKVM runtime to run this.
>
> Thoughts?
>
> ------------------------------------------------------------------
> //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
> using System;
> using org.apache.poi.hssf.usermodel;
> using ikvm.lang;
>
> class MainClass
> {
> public static void Main(string[] args)
> {
> Console.WriteLine("Hello World!");
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet s= wb.createSheet("Sheet1");
> HSSFRow r= s.createRow(0);
> HSSFCell c = r.createCell(1);
> c.setCellValue(1);
> java.io.FileOutputStream fs = new
> java.io.FileOutputStream("dotnet.xls");
> wb.write(fs);
> fs.close();
> }
> }
> -------------------------------------------------------------------
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
RE: POI in .NET
Posted by Kais Dukes <kd...@kaisdukes.com>.
Hi Avik
That’s really cool.
Is this just HSSF, or Word as well??
Kind Regards,
Kais
-----Original Message-----
From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
Sent: 08 July 2004 14:50
To: poi-user@jakarta.apache.org
Cc: poi-dev@jakarta.apache.org
Subject: POI in .NET
Have you yearned to use the wonders of POI in you .NET applications?
Well, then yearn no more. POI compiled into a .NET dll is available at
http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
The following C# code uses poi to create a new excel file.. it compiles
and runs successfully .. tested in mono, should be fine in windows as
well. Of course, no warranties, it may eat your homework :)
Done with IKVM. You need to download the IKVM runtime to run this.
Thoughts?
------------------------------------------------------------------
//Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
using System;
using org.apache.poi.hssf.usermodel;
using ikvm.lang;
class MainClass
{
public static void Main(string[] args)
{
Console.WriteLine("Hello World!");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s= wb.createSheet("Sheet1");
HSSFRow r= s.createRow(0);
HSSFCell c = r.createCell(1);
c.setCellValue(1);
java.io.FileOutputStream fs = new
java.io.FileOutputStream("dotnet.xls");
wb.write(fs);
fs.close();
}
}
-------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
RE: POI in .NET
Posted by Kais Dukes <kd...@kaisdukes.com>.
Hi Avik
That’s really cool.
Is this just HSSF, or Word as well??
Kind Regards,
Kais
-----Original Message-----
From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
Sent: 08 July 2004 14:50
To: poi-user@jakarta.apache.org
Cc: poi-dev@jakarta.apache.org
Subject: POI in .NET
Have you yearned to use the wonders of POI in you .NET applications?
Well, then yearn no more. POI compiled into a .NET dll is available at
http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
The following C# code uses poi to create a new excel file.. it compiles
and runs successfully .. tested in mono, should be fine in windows as
well. Of course, no warranties, it may eat your homework :)
Done with IKVM. You need to download the IKVM runtime to run this.
Thoughts?
------------------------------------------------------------------
//Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
using System;
using org.apache.poi.hssf.usermodel;
using ikvm.lang;
class MainClass
{
public static void Main(string[] args)
{
Console.WriteLine("Hello World!");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s= wb.createSheet("Sheet1");
HSSFRow r= s.createRow(0);
HSSFCell c = r.createCell(1);
c.setCellValue(1);
java.io.FileOutputStream fs = new
java.io.FileOutputStream("dotnet.xls");
wb.write(fs);
fs.close();
}
}
-------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org