poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aisha Urooj <aukhan...@hotmail.com>
Subject Re: 3.7 beta release?
Date Fri, 11 Jun 2010 05:42:58 GMT

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: dev-unsubscribe@poi.apache.org
>>>>>>>> For additional commands, e-mail: dev-help@poi.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>              
>>>>>>> ---------------------------------------------------------------------
>>>>>>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>>>>>>> For additional commands, e-mail: dev-help@poi.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>            
>>>>>>
>>>>>>          
>>>>>
>>>>>        
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>>>> For additional commands, e-mail: dev-help@poi.apache.org
>>>>
>>>>
>>>>
>>>>      
>>>    
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>> For additional commands, e-mail: dev-help@poi.apache.org
>> 
>> 
>> 
> 
> 

-- 
View this message in context: http://old.nabble.com/3.7-beta-release--tp28757813p28851509.html
Sent from the POI - Dev mailing list archive at Nabble.com.


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


Mime
View raw message