Comments on Coding Thoughts: Using POI to Export Lotus Notes Data to Excel

this is a earlier code that have various errors i ...

2010-05-03T18:14:16.582-04:00

this is a earlier code that have various errors i will try to put some good code just a example for you analyse

thanks

import org.apache.poi.hwpf.usermodel.*; import org...

2010-05-03T18:12:22.956-04:00

import org.apache.poi.hwpf.usermodel.*;
import org.apache.poi.hssf.model.*;
import org.apache.poi.hssf.*;

import org.apache.poi.hwpf.HWPFDocument;

import org.apache.poi.hwpf.usermodel.Range;
import org.apache.poi.hwpf.usermodel.Paragraph;
import org.apache.poi.hwpf.usermodel.Table;
import org.apache.poi.hwpf.usermodel.Section;

import java.util.Map;
import java.util.HashMap;
import java.util.Calendar;
import java.io.FileOutputStream;
import java.text.SimpleDateFormat;
import java.io.FileOutputStream;

import lotus.domino.*;
import java.util.*;
import java.text.*;
import java.io.*;
import java.lang.*;
import java.util.Date;
import java.io.PrintWriter;

public class Word
{
/*
openDocument
openParagraph
openBody
openSection
openTitle
openSource
writePlainText
closedocument...

*/
private int curRow;
// private POIDocument(dir, filesystem);
// private HSSFWorkbook curWB;
// private HSSFSheet curSheet;
// PrintWriter pw = getAgentOutput(); +"
" // erro
/* public boolean Range(int start, int end, HWPFDocument doc)
{
try {

} catch(Exception ex)
{
ex.printStackTrace();
return(false);
}
} */

public boolean writeWordHeader(String[] rowValues)
{
try {
this.curRow = 0;
// this.curWB = new HSSFWorkbook();
// this.curSheet = this.curWB.createSheet("Sheet1");

//This will write the header row
System.out.println("estou no header \n");
return(this.writeToWord(rowValues));
} catch(Exception ex) {
ex.printStackTrace();
return(false);
}

}
public boolean writeToWord(String[] rowValues) {
System.out.println("valor da linha: ");
System.out.println("valor: " + rowValues);
try {

// HSSFRow row = this.curSheet.createRow(this.curRow);

for(int i = 0; i < rowValues.length; i++) {
// row.createCell(i).setCellValue(new HSSFRichTextString(rowValues[i]));
System.out.println( "linha: " + rowValues[i]);
}

// this.curRow++;

} catch(Exception ex) {
ex.printStackTrace();
return(false);
}

return(true);
}
public boolean writeWordFile(String fileName)
{
System.out.println("filename: " + fileName);
try {
//Auto fit content

for(int i = 0; i < 20; i++) {
// this.curSheet.autoSizeColumn((short)i);
}

// Write the output to a file
FileOutputStream fileOut = new FileOutputStream(fileName);
System.out.println("nome: " + fileOut);
// this.curWB.write(fileOut);
fileOut.close();
} catch(Exception ex) {
ex.printStackTrace();
return(false);
}

return(true);

}
}

Hi Carlos, Thank you for your understanding and an...

2010-04-29T19:50:44.773-04:00

Hi Carlos, Thank you for your understanding and answer, i´m sorry i lost your page so just today i could see it.

Yes i have errors and i can post some of my code that i worked to get the word file, its dificul since i dont program a lot in java just lotuscript, javascript a litle to.
well i onnly can read and create a file .doc/.docx but mt error was to write inside it some string/phrase.
I will post soon, i leave a rest a while because now i´m learning were i work smallworld magik programming its diferrent programming like c++ you know gis?

well for now i will return to the POI Vs word.

Thank you beste regards

Hi Caldeira, Are you trying to export data from L...

2010-04-18T11:19:35.967-04:00

Hi Caldeira,

Are you trying to export data from Lotus Notes to a Word document? Are you getting any specific error?

I will create a simple example of doing this with the Apache POI Project and post soon.

Hi, I enjoy your code its really works thank you...

2010-04-16T06:18:35.927-04:00

Hi,

I enjoy your code its really works thank you.
All do i´m triyng to do the same with word documents but with no success!!! are doing the same? Will you try it out?

Regards

Filipe