Axolot Data

Hello Lars,

Resulting template now looking nice and promising!
(Just need to figure out how to renew a pivot table)

Thanks,
Marius

Hello Lars,

The 5.20.7 raises an access violation in the DeleteRows method.

Regards,
Marius

Hello Lars, Sigh, sorry man, I stumbled on yet another formula problem, the DeleteRows (the correct one this time) does not adjust formula's. After the sample code the original formula SUM(A1:A25) is SUM(A1:A35), same for the other vertical formula's, horizontal formula is also affected. The named r...

Whoops, I automaticly assumed the same parameters, its not as consistent as i thought

Sorry for the disturbance
Marius

Hello Lars,

I was already afraid of it but was unable to find any other stuff (and obviously overlooked the property names).
Your helpfiles really lack a searchable format, and codesnippets etc etc

But thank you Lars,
Marius

Hello Lars, I stumbled on a other problem, the DeleteRows does not seem to work. You can reuse the sample i send to you, just replace the (only) line in the TfrmMain.btnCopyClick with this. XLS[0].InsertRows(10, 5); XLS[0].InsertRows(10, 5); XLS[0].DeleteRows(10, 5); XLS[0].DeleteRows(10, 5); Regard...

Hello Lars, I'm trying to create a named range in an excel sheet but have no idea how to accomplish this in TXLSReadWriteII5. The helpfile wont give me much decent answers (is there a searchable chm file, because html is limited in search?) (The only thing i could find close to a range was a propert...

Thanks, its indeed fixed.

Now I can start my testing with template excel files in combination with pivot tables!

larsa wrote:Hello

Can you please give me a complete code sample?

Example code send to support email..

Thanks,
Marius

Hello Lars, I upgraded to version 5.20.04a, but problems again. Rows are being inserted, but the named range is not extended and the sum formula's are not adjusted. i used Samples\Delphi\CopyMoveDelete as a demo, adjusted the copy code to this, run, button "read", button "Copy, Move a...

Thank you!

I will re-test later this week

I'm evaluating TXLSReadWriteII5 version 5.20.03a on Delphi XE. We want to use excel templates with a named ranges to 'feed' pivottables and charts. As an example, the pivottable and charts are on sheet 1 and all the data will be in sheet 2. The data consists of 2 columns name and value, has initiall...