How to Create Excel File With PivotTable and Chart Via VJ++ 
Author Message
 How to Create Excel File With PivotTable and Chart Via VJ++

Hello Sir,

I have a problem, I am trying to create a new Excel file
via VJ++. And also I want to add PivoteTable and Chart
into that created Excle file. I am able to open a Excel
file but I am not able create a new Excel file. Can you
tell how I can create a Excel file with Pivote Table and
Pivote Chart using Visual J++ as well as please tell me
how i can provide Data Source to Pivote Table in VJ++ . I
am useing Sql Server 2000 Here is my code I am useing to
open a Excel file. Please help me on this matter Thanks.

Vijay Mundhe

//Code of Visual J++(VJ++) which i wrote
import java.sql .* ;
import* ;
public class PivotTable

    private String UserName;
    private String Password;
    private Connection conn;
    private Statement st1;
    private ResultSet rs1;
    private excel.Application app;
    private excel.Workbook  w1;
    private excel.Worksheet ws;
    private excel.PivotTable pt;
    private String ds;

    private Variant noParam = new Variant();
    public static void main (String[] args)
        PivotTable pttb = new  PivotTable();
    public void creaeTable()

        System.out.println("In createTable method");
        excel.Range range = null;
        int lcid = cale.getUserDefaultLocale().getLCID();
        app = new excel .Application ();
        ws = new excel.Worksheet();
        app.setVisible (lcid,true); f1;
        String file;
        String filename  
        f1 = new (filename);
        if(f1.exists() )
        System.out.println ("opening this
File :"+filename);
        app.getWorkbooks ().Open(filename,noParam,new
        w1 = app.getActiveWorkbook ();;

            //Here if File is not found then I want to
            //create a new Excel file and add Pivot table  
            //and add Dimension and Measures to that
            System.out.println("File not found");
    }//try end
    catch(Exception e)
        System.out.println("Error : " + e.getMessage());
    }//catch end

   }//createTable method end


Sat, 04 Jun 2005 15:34:39 GMT  
 [ 1 post ] 

 Relevant Pages 

1. PivotTable and VJ++

2. vj++ ide crash

3. Using VBA to create charts from Pivottable

4. Using VBA to create charts from Pivottable (**complete**)

5. Make my macro select a limited pivottable before creating a chart

6. Totals different in OWC PivotTable than in Excel PivotTable

7. Creating charts for a bunch of excel files???

8. Excel 2000 Charting from a Pivot Table w/o creating a Pivot Chart

9. Cannot Open Excel File via Outlook or via Windows Explorer

10. Create email with embedded Excel document via Excel VBA

Powered by phpBB® Forum Software © phpBB Group