Skip to Content (Press Enter)
OutSystems.com
Personal Edition
Community
Support
Training
Training
Online Training
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Jobs
Ideas
Members
Mentorship
User Groups
Platform
Platform
ODC
O11
Search in OutSystems
Log in
Get Started
Back to Forums
Gerry
0
Views
8
Comments
Turn Web block into Excel export
Question
I have a web block containing a table records widget which represents the detail records for something. How can I turn this into an excel export?
Miguel Seabra Melo
Hi Gerry,
Have a look at this thread
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?TopicId=2749&Topic=Sample%3A-Producing-fully-styled-Excel-reports
it may have what you need.
Cheers,
Miguel
4 replies
Last reply 03 Jul 2012
Show thread
Hide thread
Gerry
Miguel Melo wrote
:
Hi Gerry,
Have a look at this thread
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?TopicId=2749&Topic=Sample%3A-Producing-fully-styled-Excel-reports
it may have what you need.
Cheers,
Miguel
Thanks. However, the application does not run in v6.0. It's looking for "https://localhost/NiceExcelReport/web.css" which I'm getting a 404 error on. What should that be in v6?
Gerry
Gerry wrote
:
Miguel Melo wrote
:
Hi Gerry,
Have a look at this thread
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?TopicId=2749&Topic=Sample%3A-Producing-fully-styled-Excel-reports
it may have what you need.
Cheers,
Miguel
Thanks. However, the application does not run in v6.0. It's looking for "https://localhost/NiceExcelReport/web.css" which I'm getting a 404 error on. What should that be in v6?
Does anyone have any insight on this? I would really like to get this to work without errors. TIA!
Ivo Gonçalves
Gerry wrote
:
Gerry wrote
:
Miguel Melo wrote
:
Hi Gerry,
Have a look at this thread
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?TopicId=2749&Topic=Sample%3A-Producing-fully-styled-Excel-reports
it may have what you need.
Cheers,
Miguel
Thanks. However, the application does not run in v6.0. It's looking for "https://localhost/NiceExcelReport/web.css" which I'm getting a 404 error on. What should that be in v6?
Does anyone have any insight on this? I would really like to get this to work without errors. TIA!
Hi Gerry,
On 6.0 version you get the 404 http error because the eSpace CSS is no longer defined on the web.css. In the new version you have the
Theme
concept, which you can check by opening your eSpace. On the Interface tab you have a folder named Themes. Inside that folder you have all the available style sheets that you can use on your application.
When you upgrade an eSpace from 5.1 to 6.0 the CSS is renamed. If you want to access to eSpace style sheet you have to use the following pattern:
https://<Server>/<eSpaceName>/Theme.<eSpaceName>Theme.css
Following your example it should be like this:
https://localhost/NiceExcelReport/Theme.NiceExcelReportExcelTheme.css
Hope this helps
Ivo Gonçalves
Gerry
Ivo Gonçalves wrote
:
Gerry wrote
:
Gerry wrote
:
Miguel Melo wrote
:
Hi Gerry,
Have a look at this thread
https://www.outsystems.com/NetworkForums/ViewTopic.aspx?TopicId=2749&Topic=Sample%3A-Producing-fully-styled-Excel-reports
it may have what you need.
Cheers,
Miguel
Thanks. However, the application does not run in v6.0. It's looking for "https://localhost/NiceExcelReport/web.css" which I'm getting a 404 error on. What should that be in v6?
Does anyone have any insight on this? I would really like to get this to work without errors. TIA!
Hi Gerry,
On 6.0 version you get the 404 http error because the eSpace CSS is no longer defined on the web.css. In the new version you have the
Theme
concept, which you can check by opening your eSpace. On the Interface tab you have a folder named Themes. Inside that folder you have all the available style sheets that you can use on your application.
When you upgrade an eSpace from 5.1 to 6.0 the CSS is renamed. If you want to access to eSpace style sheet you have to use the following pattern:
https://<Server>/<eSpaceName>/Theme.<eSpaceName>Theme.css
Following your example it should be like this:
https://localhost/NiceExcelReport/Theme.NiceExcelReportExcelTheme.css
Hope this helps
Ivo Gonçalves
Thank you very much for responding. I tried to change the stylesheet as you have suggested and still get a 404 error on that exact line. At first I thought there was a misspelling, so I tried the following with no luck:
https://localhost/NiceExcelReport/Theme.NiceExcelReportExcelTheme.css
https://localhost/NiceExcelReport/Theme.NiceExcelReportTheme.css
https://localhost/NiceExcelReport/Themes.NiceExcelReportTheme.css
Could you please check that file reference?
Thanks,
Gerry
Nuno Reis
Â
MVP
Got the same error. On the 5.1 server it works, on the 6.0 it doesn't.
A turn around would be to load the css like a resource...
Nuno Reis
Â
MVP
Gerry, try this:
GetBookmarkableURL()+"Theme.AppName.css"
in your case
https://localhost/NiceExcelReport/
Theme.
NiceExcelReport
.css
1 reply
05 Jul 2012
Show thread
Hide thread
Gerry
Nuno Reis wrote
:
Gerry, try this:
GetBookmarkableURL()+"Theme.AppName.css"
in your case
https://localhost/NiceExcelReport/
Theme.
NiceExcelReport
.css
What happens is that I get an error in Excel:
Then the spreadsheet appears with the data, but no colors.
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
See the full guidelines
 Loading...