It looks you can't make a pivot table directly from an array. What you could do though is write the array to a text file and base the array on that file as an external data source via a text driver. Another option is build your pivot table in code, not using the Excel pivot table object.
RBS On Thu, Oct 13, 2011 at 8:44 PM, Bart Smissaert <bart.smissa...@gmail.com> wrote: >> My problem is that the data basis of the Pivottable will sometimes be > millions of rows > > OK, I haven't got that problem and my pivots are based on a sheet range. > Sheet range is based on a variant array obtained from SQLite. > I will need to check, but I think you can use an array for the basis of a > pivot. > > RBS > > > On Thu, Oct 13, 2011 at 8:36 PM, Frank Missel <i...@missel.sg> wrote: >> Hi Bart, >> >>> Interesting. Why, if you had a well performing VB wrapper, did you go this >>> route? >> >> 1. Implementing the wrapper in the project code would also take some coding, >> and I found that using the C API would not be that much extra work. Thus I >> could save a layer, which was good as the project had several other layers >> already. >> >> 2. The project required heavy data loads. I thought that I could get better >> performance and control of data validation, i.e. I could decide exactly how >> much and what to have. >> >> 3. It was a bit fascinating to get to work close to engine -- minimalistic >> and effective is always fascinating :-). >> >>> > If anyone have any solution for this or any other, easier alternative >>> > way of >>> accessing an SQLite database as a data source programmatically >>> >>> This is exactly what I do and no problem at all for example to produce a >> pivot >>> table based on data from SQLite. >> >> Interesting, how do you get the data from the table or view into Excel to be >> the basis of the Pivottable? >> Do you paste it to a worksheet (perhaps as arrays) that then becomes the >> basis of the Pivottable? >> >> My problem is that the data basis of the Pivottable will sometimes be >> millions of rows, i.e. many more than can be contained in a worksheet. >> But when referencing the data source directly as a proper data source the >> number of rows are not limited to the maximum number of allowed rows in a >> worksheet. >> >> /Frank >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users