Fog Creek Software
Discussion Board




excel webquery limited to 100 rows?

has anybody else runs into this?
when i try to import an html table (actually list of bugs from bugzilla), I could only import 100 rows from it.

i dont know what is it but it does seem that webquery as defined in MS-Excel is limited to 100 rows of data.

Has anybody else has also run into this limitation. Is there a way of bypassing it.

Tarun Upadhyay
Monday, October 06, 2003

www.extrasheet.com is an online database system which uses Microsoft Excel for reporting, via a webquery.  It successfully exports many thousands of rows if required.

David Adams
Monday, October 06, 2003

>"excel webquery limited to 100 rows?"
I guess this has do with some setting in BUGZILA.

I have my custom Bug Tracking system with the same feature of converting html into EXCEL.

It exports more than 2000 rows without any problem.

BSA
Wednesday, October 08, 2003

*  Recent Topics

*  Fog Creek Home