Aisha,
Please send usage questions to the poi-user list. This thread is intended to
discuss upcoming release of POI 3.7 beta.
It is hard to suggest a solution without knowing all the details. If you know
the number of records in advance then the evident answer is to update you pivot
table and chart first and then use the BigGridDemo approach to fill data.
Can you modify you pivot table and chart to refer to a defined name instead of
a hardcoded cell range? The defined name can refer to a formula that would
automatically pick up a range from the data sheet.
Yegor
Hi
I am waiting if anyone can help me in this problem......how can i update my
pivot table range using POI each time i update data in data sheet.
Some one help plz..
Aisha Urooj wrote:
Thanks Yegor....it is working for me now.....i have pivot table and chart
on my other two sheets having defined ranges for lets say 100 records from
datasheet. Now if i am adding 200 more records into my Data Sheet using
your approach, i want to update the other sheets too so that they also
reflect the newly added records.........i want to adjust range for both
pivot table and chart everytime i add new records to data sheet , it could
be a bit tricky as i dont know how many records i am going to write each
time....so if you can help me in that too.
Yegor Kozlov wrote:
what exactly do you want to change on the other two sheets? Can you
setup your template first and then insert the data using the BigGridDemo
approach?
To write data into a sheet in an existing template you should change the
following line in BigGridDemo.java
XSSFSheet sheet = wb.createSheet("Big Grid");
to
XSSFSheet sheet = wb.getSheet("My Data");
where "My Data" is the name of your data sheet.
Yegor
Okay, thanks Yegor for your quick response.
Well I want to use the approach you used in BigGridDemo, i.e. to write
data
on a temporary file and then to my .xlsx file. I am sorry as i am new to
POI
, and as in your approach you are replacing the data into a new
template.
I need to write data onto an existing .xlsx file will be having three
sheets
, one will be showing the pivot chart, 2nd is for pivot table and the
last
will be my data sheet which is being used by the other two sheets.Now i
need
to write that data sheet but it gives me an out of memory error. Now if
i
refer to your code, i dont need to write a template first, i just want
to
read my existing .xlsx file and alter the contents of my data sheet, it
will
be good if i could be able to change the other two sheets too with
respect
to my data going into datasheet. I tried to read my xlsx file instead of
creating the template (may be i am wrong here) but it ofcourse is giving
me
heap size error. Can you help me in it??I dont just want to write data
into
a new file, copying the pivot and chart in are important part of this
research.
hope you will help me in it.
Thnx :)
Yegor Kozlov wrote:
Aisha,
please post your questions on the mailing list. This is the "apache
way"
of finding information.
Yegor
Urooj wrote:
Hi Yegor
May be it is not the appropriate forum to write on....but i do need
your
urgent help in an issue related to the memory workaround issue you
resolved in BigGridDemo. Can i have your email address where i can
contact
you?Plz its urgent......looking for your reply
and once again sorry for contacting you on this forum:-(
Regards
Aisha
Yegor Kozlov wrote:
+1
Yegor
Hi All
I was thinking about doing a beta release for 3.7 sometime soon.
While
we haven't had that many new features added since December, there
have
been loads of bug fixes (or so status.xml tells me!), so it's
probably
worth getting a slightly wider set of people to try it out.
Certainly
text extraction has had a updates that could use some wider
checking!
As Yegor's a little busy at the moment, I'm happy to cut the beta
release, and hopefully Yegor'll be able to resume RM duties for the
-FINAL in a month or two.
Does anyone see a reason not to do a beta release next week? (well,
build the release artificats and start the vote next week, probably
with voting finishing just into the week after) Hopefully everyone
can
get any fixes in that they'd like for the beta in the mean time :)
Cheers
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
