May have found a way... It seems possible to tell Excel to import a given
table in a page :
http://office.microsoft.com/en-us/excel-help/get-and-analyze-data-from-the-web-in-excel-HA001054848.aspx
Point 3 :
- *Only the tables* returns all tables or preformatted (<PRE>) sections
on the page. Use this option when you do not want to import
advertisements,
banners, navigation, or other elements on a page.
- *One or more specific tables on a page* returns only the table(s)
that you specify. Use this option when you want data out of a specific
table or tables only.
[image: Hide]To specify which tables to return
Enter table numbers separated by commas (such as 2, 3, 4 to return the
second, third, and fourth tables on the page) or enter table names in
quotation marks, separated by commas (such as "Table 1","Table 2"). You can
specify the tables—and preformatted sections (<PRE>), which are recognized
as tables—by counting them or by entering their names if they are defined
on the Web page.
You may need to view the HTML source code to determine the table name or
number. The table name is defined on the Web page by the ID tag in the
TABLE attribute (for example, <TABLE ID="My Table" where "My Table" is the
table name). See the Help in your browser for information on how to view
HTML source code.
I will try this tomorrow...
Richard
On Mon, Jan 27, 2014 at 4:10 PM, Richard Vézina <[email protected]
> wrote:
> Yes I guess I need to write my own serializer...
>
> I will work on it and figure how excel will digest xml...
>
> Thanks
>
> If applies I will write a slice when I have something interresting, that
> could maybe goes in the book as an example...
>
> Richard
>
>
> On Mon, Jan 27, 2014 at 4:04 PM, Niphlod <[email protected]> wrote:
>
>> the whole point of rname is decoupling and "masking" the underlying
>> backend identifiers without changing the model entities.
>>
>> I don't think that rname will (or should) be exposed when serializing the
>> rows object (that, BTW, doesn't and shouldn't retain any notion of rname)
>>
>> You'll probably need to figure out what you want and build your own
>> serializer (not difficult at all)
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
