[prev in list] [next in list] [prev in thread] [next in thread]
List: poi-dev
Subject: Re: POI in .NET
From: acoliver () apache ! org
Date: 2004-07-19 13:08:28
Message-ID: 8505448.1090241616147.JavaMail.root () set ! superlinksoftware ! com
[Download RAW message or body]
Thatıs 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)
--
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 <avik.sengupta@itellix.com>
> Reply-To: "POI Developers List" <poi-dev@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
>
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic