http://forums.visokio.com/discussions/tagged/export-to-Excel/feed.rss Mon, 30 Oct 17 12:13:22 -0400 Tagged with export-to-Excel - Visokio Forums en-CA http://forums.visokio.com/discussion/3265/exporting-pivot-view-data-into-xls Fri, 25 Aug 2017 08:14:37 -0400 enrico68 3265@/discussions
I followed what is indicated in the thread http://forums.visokio.com/discussion/comment/10597/#Comment_10597 but I've been able only to extract the details of the elementary records that are the base for the pivot composition.

Is it possible to extract the data as shown in the pivot table?

Since the pivot table is very big I would like to avoid to use the method of selecting cells on the pivot and use the cut and paste option.

]]> http://forums.visokio.com/discussion/3087/batch-output-for-excel-specify-starting-rowcolumn Wed, 03 Feb 2016 11:11:49 -0500 OliverB 3087@/discussions Last year we had a request to add some functionality to the batch config file so that when publishing to excel, we could use the Replace Data/Replace Worksheet/Overwrite data etc functionality that the individual data manager output blocks have . This was implemented and works very well.

http://forums.visokio.com/discussion/2862/batch-publishing-output-excel-using-template-filess

One other functionality that the data manager file output block has that doesn't appear to be available in the batch config files is to be able to specify a row or column to start inserting the data at. Would it be possible to add this functionality to the batch config file as well?
Thanks

Ollie.]]> http://forums.visokio.com/discussion/3215/batch-export-excel-font-settings Sat, 18 Feb 2017 13:25:38 -0500 enrico68 3215@/discussions I'd like to know if it's possible to create these files imposing a particular font (different from xlsx standard one).

This is because this automatically created xlsx files will be used to populate ppt documents passing specific data and these presentation will have to satisfy company defined standards.]]> http://forums.visokio.com/discussion/2862/batch-publishing-output-excel-using-template-filess Mon, 09 Mar 2015 13:00:19 -0400 OliverB 2862@/discussions
I am trying to create a set of Excel reports, each containing multiple sheets. The reports need to be formatted in a certain way (i.e. date formats, header rows shading etc)

I can do this using the data file output in DataManager, just by writing to a blank Excel file that already exists and has formatting applied. However, I have about 100 Excel reports, each with 6 worksheets, so this method will be very time consuming to set up and maintain.

I have tried to set this up using a batch output. I am able to actually create the raw data files, but these do not have the formatting that I need. I have created a template Excel file (I've tried .xls and .xlsx) which has all of the formatting applied. However, when I point the batch config to this template file and set the "Preserve template formatting and formulas" to 'true', this does not have any effect?

I have also tried to create a file with the same name as the output, the same way as I would do this using DataManager, but this doesn't work either, the existing worksheets are just totally overwritten.

Is there a way for me to accomplish this without having to create this all manually in DataManager?]]> http://forums.visokio.com/discussion/2851/idea-menu-icon-for-exporting-to-excelcsv-from-browser-views Fri, 20 Feb 2015 10:40:03 -0500 aknotts 2851@/discussions
Andy]]> http://forums.visokio.com/discussion/2805/outputs-exporting-to-excel-using-different-optionss Wed, 07 Jan 2015 04:29:57 -0500 benjamin 2805@/discussions
When I publish to an Excel workbook using a DataManager block using the Omniscope route rather than the Excel Direct option, the resulting Excel file is smaller (which is good)

However, if I keep on publishing to the same file using Omniscope route the file size increases, when the data set has not changed.

Why is this ?

Thanks

Ben]]> http://forums.visokio.com/discussion/2772/export-cut-and-paste-from-table-view-to-excel Thu, 27 Nov 2014 09:32:47 -0500 enrico68 2772@/discussions
The result obtained is in picture 2: as you can see, when copied to Excel, the detail rows mantain the correct numeric and percentage format while Total rows are not interpreted correctly: they are text and no more numeric values.

Our users need to use cut-and-paste because they would like to export also the total rows and these rows are not exported in Excel when the export function in admin menu is used.

Is there a solution to this problem? Why are the total rows are handled in a different way then detail rows? ]]> http://forums.visokio.com/discussion/2820/outputs-excel-file-open-in-another-applications Mon, 19 Jan 2015 11:03:27 -0500 alex7thompson 2820@/discussions
Please can I get some assistance.

]]> http://forums.visokio.com/discussion/2776/idea-un-couple-view-toolbar-display-from-export-data-in-browser-versionss Tue, 02 Dec 2014 06:37:13 -0500 aeastwood 2776@/discussions
I could be wrong, but it seems that when a file is opened in HTML5 web version, the export data option (represented as a cloud icon in the top right) for each data view is only available when the view toolbar is set to show (rather than e.g. pop out) for that view.

If I'm wrong, please let me know what I should be doing differently. Otherwise, I think it'd be useful if these two functions were uncoupled - for example it could be problematic if I wanted a file to be viewable by end users both in HTML5 web version and in the Omniscope Desktop IOK free Viewer version, since either the web version user would be unable to export data or the Desktop IOK free Viewer user would see a more cluttered presentation. It's only a small thing but would make life a little easier.

Thanks,
Alex]]> http://forums.visokio.com/discussion/2735/export-enable-export-view-data-from-browser-deployed-html Wed, 01 Oct 2014 06:19:15 -0400 paola 2735@/discussions
This option can be enabled from Desktop Edition or from the Server interface.

Desktop steps:
Settings>Web sharing>Edit client settings>Server settings Edit>Export view data

Server steps:
From the Omniscope Web Server Services screen>Config>Permissions>Default Folder Config> Anonymous permissions>Export view data

This option will enable all recipients to export data from their browser. If you wish to customise this further and enable it only for certain groups of users, please create Groups settings (as per image).

]]> http://forums.visokio.com/discussion/2752/export-grouped-table-view-data-to-excels Sun, 02 Nov 2014 14:06:51 -0500 kmatrix999 2752@/discussions
I have grouped and filtered data in table view. I have tried to export the data to Excel but lose the grouping.

Is there a way to export data to Excel and retained the grouping and sub totals?]]> http://forums.visokio.com/discussion/2672/pivot-view-view-data-exported-to-excels Mon, 04 Aug 2014 03:55:11 -0400 Avizua 2672@/discussions
Thanks, Magali]]> http://forums.visokio.com/discussion/2509/export-error-saving-exported-excel-files Tue, 01 Apr 2014 04:56:08 -0400 Master_Chief 2509@/discussions An error occurred saving "visokio_temp_tempres8058354335559329865.xlsm":
Microsoft Office error
80010001 / Call was rejected by callee. A backup of the previous file was created at

Local\Temp\visokio_temp_tempres8058354335559329865 (backup).xlsm" A further error occurred restoring the backup: Cannot access file: The file you are trying to access is currently open in another program (such as Microsoft Excel). Please close these application(s) and try again.

Local\Temp\visokio_temp_tempres8058354335559329865.xlsm (The process cannot access the file because it is being used by another process)]]> http://forums.visokio.com/discussion/2442/content-view-exporting-html-tables-to-an-excel-files Wed, 15 Jan 2014 06:33:38 -0500 enrico68 2442@/discussions
This is what our 'internal customers' are requiring now.

Alternatively, we can consider the idea to export only data in a pre-formatted Excel template file. Notice, however, that some tables (as the second included in the attached file) have a vertical development with a variable number of rows.

If such an export option exists, is it possible to have any example on how to implement it?

Thanks]]> http://forums.visokio.com/discussion/2366/export-disabling-export-view-data-for-some-userss Mon, 07 Oct 2013 05:27:14 -0400 DominicChan 2366@/discussions
Can you advise if its possible to disable the "Export View Data" function for some users (either by making a different report or by Password rights)? We are getting a good handful of new end users, and we will like to make sure the new end-users dont get to export any data at all to Excel.

Is this possible? Please advise with some instructions.

Thanks a lot,
Dom ]]> http://forums.visokio.com/discussion/2026/pivot-view-copy-result-as-pivot-table-into-excels Thu, 21 Feb 2013 10:09:31 -0500 bfromson1 2026@/discussions
The "export view data" option exports all the underlying data - in a Table View the export view data actually exports the table as viewed?]]> http://forums.visokio.com/discussion/2098/outputs-exporting-to-excel-xlsmxlsxs Fri, 19 Apr 2013 01:16:33 -0400 Mai 2098@/discussions Thanks for your advice.
Regards, Mai]]> http://forums.visokio.com/discussion/1994/outputs-export-to-excel-using-mac-column-formattings Wed, 23 Jan 2013 06:35:57 -0500 Barcl 1994@/discussions When I export Omniscope data to an Excel file, all columns containing numbers and defined/data typed as numeric are exported to Excel as text (left aligned). Is there any way to fix it?

Thanks a lot
]]> http://forums.visokio.com/discussion/1992/outputs-export-to-excel-includes-content-view-html-tabless Tue, 22 Jan 2013 10:47:48 -0500 enrico68 1992@/discussions
I'd like to ask if it's possible to export a table produced by a Content View script (html like) to an Excel file (including or not including the Content View table formatting).

Thanks]]> http://forums.visokio.com/discussion/1864/outputs-exporting-subsets-into-spreadsheetss- Thu, 25 Oct 2012 05:08:36 -0400 ZhouNan 1864@/discussions
File > Export > Create Excel Spreadsheet

It allows me to choose which fields/columns to be exported but not to select the subset of rows that come from each differnent source. Because the file contains multiple data sources, there are many unrelated and empty fields exported with the filtered-in subset which are hard for user to process in Excel.

Is there a way to export only the rows/columns that come from the same data source? ]]> http://forums.visokio.com/discussion/1827/outputs-exporting-to-excel-underneath-saved-worksheets Thu, 11 Oct 2012 13:57:34 -0400 SherrickChavda 1827@/discussions
Through Omniscope we are pulling and working on Daily Reports so we'd like for the data to archive and collate into one big Excel file. Any help would be greatly appreciated.

Thanks, Sherrick]]> http://forums.visokio.com/discussion/1797/free-viewer-export-to-excel-from-free-viewers Fri, 28 Sep 2012 07:28:45 -0400 p_parry 1797@/discussions
I CAN export this by using my Desktop Edition by selecting File->Export->Create Excel Spreadsheet and then chosing the option to export selected data. Please can I ask if firstly if I am missing something and this functionality is available in the free Viewer but I'm unable to find it? and secondly if I'm not missing anything, would it not be far more useful to have this function in the free Viewer from a data visibility point of view? N.B. I am currently operating on version 2.7 b734]]> http://forums.visokio.com/discussion/1665/free-viewer-export-to-excel-from-free-viewers Mon, 23 Jul 2012 06:27:18 -0400 OmarKhan 1665@/discussions http://forums.visokio.com/discussion/1577/outputs-export-to-excels Mon, 04 Jun 2012 16:43:43 -0400 davedunckley 1577@/discussions
I have tried converting them to numbers, and then asking Omniscope to export with replace data -keep formatting. However they then end up back as text. Any ideas? Any one else able to recreate this issue?

Thanks in advance, Dave]]> http://forums.visokio.com/discussion/1322/export-file-security-and-export-to-excel-options Mon, 20 Feb 2012 04:00:56 -0500 Mees 1322@/discussions Export to Excel is possible in case a user has a paid license on Omniscope.
When opening an iok file via Java webstart, the Viewer that opens doesn't provide the export option.
This is normal behaviour, but it would be very useful to enable us to give users with a paid license the export functionality in the web start viewer.

We often get this question and cannot deliver as we use webstart.

Just sending the iok file directly would solve the problem, but then we loose control over our file. In addition we monitor the usage of webstart and we loose this as well when sending the file directly.

Is there anything you can do to help?

Thanks ]]> http://forums.visokio.com/discussion/675/outputs-export-to-pre-formatted-excels Fri, 11 Mar 2011 05:00:37 -0500 Jasper 675@/discussions ]]>