opening sod in xls format.

[Nandha]

Hi,

I am new to espredengine API , i have designed some reports in spreadsheet when i tried open it in XLS format from my appliction i have some problem.

The size of the file reduced and i was not able to reuse the SOD file and i couldnt get the XLS file also my code is

import java.io.File;
import com.f1j.ss.*;
import java.io.*;
public class sod
{
public void doGet() throws Exception
{Document doc = null;
FileOutputStream fos = new FileOutputStream ("c:\\cash.sod");
DataOutputStream out = new DataOutputStream(fos);
try {
File templateFile = new File("c:\\cash.sod");
doc = new Document(null, templateFile, new DocumentOpenCallback());
doc.getLock();
doc.fileSaveAs(out, DocumentType.EXCEL_97_REPORT_VIEW, newDocumentSaveCallback()); }
catch (Exception e){System.out.println(e.getMessage()); }}
public static void main(String args[ ])
{ try{ sod m=new sod(); m.doGet();}
catch (Exception e){System.out.println(e.getMessage());}}}

Kindly help me in solving this issue.
Thanks in advance
Nandha

[rmurphy]

In your code you are reading in C:\cash.sod, and attempting to write out an XLS 97 file to C:\cash.sod which is the same file you read. Change the file extension of you output file to be xls instead of sod.

Rob

[Nandha]

Hi,

I changed the code as u said now, iam getting this error,there is no jdbc class files in the given jar.

do we need to create the datasource in the coding or it will use wt is available in the sod file.

My xls is generated with 0 kb

I have also attached the error log that i got.

Kindly help me in solving this issue.

Regards,
Nandha

[rmurphy]

The report that you have designed uses the Actuate Data Direct driver to access Oracle. You need to include the N_oracle.jar file in your application's classpath. You can find this jar file in the extensions directory of your e.Spreadsheet Designer installation.

Rob

[Nandha]

Rob still the problem exists , i have added the jar in the jdk exyensions even though i get this error

In the jar the classes are like com.actuate.actuatedd.jdbc.*

Is this the problem were could i get that jar file.

Kindly help me in sorting this issue.

[Nandha]

i solved this issue by using genric driver instead of Oracle(actuate) while creating the datasource in sod design time.