Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
Importance: normal
Priority: normal
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Import into Access Fails
Date: Mon, 18 Jun 2007 13:14:15 +0200
Message-ID: 
 <DCA5A4A5CADC1F4899C00EA7518C863B01E80501@ARVMAIL1.mra.roland-man.biz>
Thread-Topic: Import into Access Fails
Thread-Index: Acexmc69CfnwOWJNQoO/KEKITjXhcg==
From: <Christian_Echerer@mra.man.de>
To: <user@poi.apache.org>

I have the following test program that generates one XLS-Sheet with two
columns and one with three columns. If I try to import this XLS into
Microsoft Access 2003 (File > Get External Data > Import) for the sheet
with the even count of column only the first column is shown in the
Access dialog listing the data to be imported. For the sheet with the
odd count of columns all three columns are shown.

Is this bug in my program, in poi or in the import of access?
If i open and save the generated XLS with Excel, i do not have a problem
to import the file in access.
It seems POI writes an XLS that can not correctly be imported from
Access.


import java.io.File;
import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;


public class Main
{
    /**
     * @param args
     */
    public static void main(String[] args)
    {
        HSSFWorkbook workbook =3D new HSSFWorkbook();
        HSSFSheet sheet;
        HSSFRow row;
       =20
       =20
        sheet =3D workbook.createSheet("test_even");
        row =3D sheet.createRow(0);
        row.createCell((short)0).setCellValue(new
HSSFRichTextString("rc=3D00"));
        row.createCell((short)1).setCellValue(new
HSSFRichTextString("rc=3D01"));
        row =3D sheet.createRow(1);
        row.createCell((short)0).setCellValue(new
HSSFRichTextString("rc=3D10"));
        row.createCell((short)1).setCellValue(new
HSSFRichTextString("rc=3D11"));
       =20
       =20
        sheet =3D workbook.createSheet("test_odd");
        row =3D sheet.createRow(0);
        row.createCell((short)0).setCellValue(new
HSSFRichTextString("rc=3D00"));
        row.createCell((short)1).setCellValue(new
HSSFRichTextString("rc=3D01"));
        row.createCell((short)2).setCellValue(new
HSSFRichTextString("rc=3D02"));
        row =3D sheet.createRow(1);
        row.createCell((short)0).setCellValue(new
HSSFRichTextString("rc=3D10"));
        row.createCell((short)1).setCellValue(new
HSSFRichTextString("rc=3D11"));
        row.createCell((short)2).setCellValue(new
HSSFRichTextString("rc=3D12"));
       =20
        FileOutputStream os;
        try {
            os =3D new FileOutputStream(new File("C:/temp/test.xls"));
            workbook.write(os);
            os.close();
        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }
}

Regards
Christian

Christian Echerer
Abt.: RAEM
Dipl.-Inf.(FH)=20

MAN Roland Druckmaschinen AG
Vorsitzender des Aufsichtsrates: Hanno C. Fiedler
Vorstand: Gerd Finkbeiner (Vorsitzender), Dr. Ingo Koch, Dr. Markus =
Rall, Paul Steidle   =20
Sitz der Gesellschaft: Offenbach am Main, Registergericht: Amtsgericht =
Offenbach HRB-Nr. 42592   =20
USt-Ident-Nr. DE 250200933

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org