Q&A BY TAG 'Excel'

You must sign in to ask a question. If you do not have an account, you can register here

Unable to import XML file .
answered 30-11-2017 07:29:36 -0500

We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...

Answers: 1

Excel XML CSV XML Data Source JSON

Excel Data Source: Is it possible to create a view on a directory containing the excel files?
answered 11-10-2017 09:09:14 -0400

Is it possible to create an excel data source based on a directory of files versus an individual file? If so, how would you configure this?

Answers: 1

Excel Data Source Mulitple Files

Data Lineage Report in Excel
answered 15-09-2017 08:25:38 -0400

I have created and SOAP Service using through multi step approch creating multiple derived views from Database base views. However, I would like to capture all the linege(all intermediate steps) and Base View to Service View mappings in a spreadsheet. ...

Answers: 1

Excel Lineage

Access Live SOAP WSDL Web Service through Excel
answered 28-07-2017 09:51:02 -0400

Hi, I want to access data from a SOAP Web Service (WSDL) through Excel. I want the process to be standalone/independent from Denodo. By this I mean, even when Denodo Platform is not running behind the scenes, once the excel is loaded with the data so...

Answers: 2

Excel automate SOAP Web Service WSDL

Export the Field Name and the Field Type of a base view to an Excel File or a Delimited file
answered 16-02-2017 05:00:45 -0500

I would like to export the Metadata information for a View (the Field Name and the Field Type) to an Excel file. Please let me know how I can do so. I am using version 6.0

Answers: 1

Excel export

For Excel data source, sheet_name = 'sheet_name'?
answered 21-11-2016 16:11:39 -0500

When using an Excel workbook with multiple sheets, and specifying that data on all sheets should be returned as well as a column that contains the name of the sheet, some rows are being returned with the sheet_name as 'sheet_name' instead of the name o...

Answers: 1

Excel

Account Used to Connect to an Excel Datasource
answered 20-05-2016 06:36:55 -0400

When an Excel datasource is created, what domain account does Denodo use to connect to the Excel spreadsheet on a network file share?

Answers: 1

Excel datasource domain account

Connect to REST Web Service via MS Excel
answered 21-05-2015 18:05:05 -0400

Hi I’m hoping someone can help with a pretty basic query. I have a view that I’ve published as a REST Web Service. The view is visible via my browser the url is: http://<ipaddress>:9090/server/<environment>/drv_ibs_nav_actual_forecast_budget_unional...

Answers: 2

REST Excel Web Service