Skip to Content (Press Enter)
2012-08-01 17-33-40
Gerry
0Views
8Comments
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?
0
0
08 Jun 2012
Copy Link
2020-10-15 10-24-31
Miguel Seabra Melo
0
0
11 Jun 2012
Copy Link
2012-08-01 17-33-40
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?
0
0
11 Jun 2012
Copy Link
2012-08-01 17-33-40
Gerry
Gerry wrote:
 
 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!
0
0
13 Jun 2012
Copy Link
2020-01-10 13-55-33
Ivo Gonçalves
Gerry wrote:
 
 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
0
0
03 Jul 2012
Copy Link
2012-08-01 17-33-40
Gerry
Ivo Gonçalves wrote:
 
 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
0
0
03 Jul 2012
Copy Link
2016-04-22 00-29-45
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...
0
0
03 Jul 2012
Copy Link
2016-04-22 00-29-45
Nuno Reis
 
MVP
Gerry, try this:
GetBookmarkableURL()+"Theme.AppName.css"

in your case
https://localhost/NiceExcelReport/Theme.NiceExcelReport.css
0
0
04 Jul 2012
Copy Link
2012-08-01 17-33-40
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.
0
0
05 Jul 2012
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.