Q&A BY TAG 'Excel'

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

Cube data present in excel
answered 25-11-2021 02:18:59 -0500

Hi , i have aan excel as a source file which would be uaed in Denodo.The data is a cube. please help to find a way out to load the data in Denodo through this file. Thanks & regards, sajeda

Answers: 1

Excel

To create Excel Datasource from Sharepoint using Authorization grant as client credentials
answered 17-11-2021 16:25:29 -0500

Hello Team, When we try to create a Excel datasource from Sharepoint using OAuth2.0 with Authorization grant as Authorization code we are able to generate the code and create the datasource but it is not feasible process as we have to open the Authori...

Answers: 1

Excel SharePoint

Import file excel into bv
answered 17-11-2021 01:04:54 -0500

Hello I have a file excel present on the same machine where denodo is installed. I need to import it to be able to query it via denodo. I tried to create a new excel datasource via FTP / SFTP / FTPS Path but I don't risk it as it doesn't recognize the ...

Answers: 2

Import Excel sftp

Excel Data Source: Is it possible to create a view on a directory containing the excel files?
answered 22-06-2021 10:21:15 -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: 3

Excel Data Source Mulitple Files

Connecting to a remote Excel file using Denodo Express
answered 10-06-2021 17:05:37 -0400

Hi, I need some help trying to connect to a remote Excel file as a data source. I have two servers (A & B), server A has Denodo Express installed on it, how, do I go about connecting to a Excel file on Server B? Using the FTP or HTTP options does...

Answers: 6

Excel Denodo Express

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity
answered 08-01-2021 05:42:07 -0500

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. <Error Description when retrieving data from De...

Answers: 1

ODBC Excel Microsoft Query DENODO data types

Extract all option in Excel without sheet name is possible(Excel has multiple sheets)
answered 18-09-2020 07:54:04 -0400

Hii, I have a question related to Excel data dource wherein I am trying to create a scenario where I have multiple sheets in one single excel..say demo1.xsls. When I tick (a) Extract Sheet name as column name (b) extract data from all sheets. Then...

Answers: 1

Excel Denodo Excel Add-In

1. How one can acess Encrypted Excel file via Excel data source.? 2. using an Interpolation variable will excel file who have all different password set
answered 17-09-2020 07:49:11 -0400

I have set passowrd to Excel file and was trying to access my file but it doent helped using Decrypt(DES, MD5 ) option How can we use interpolation variable when we have lots of locked Excel file. SO I have query around password only and How ca...

Answers: 1

Excel Interpolation Variables Denodo Excel Add-In

Sharepoint/OneDrive directory access to get CSV or Excel Files
answered 18-06-2020 06:58:01 -0400

Hello Denodo! We've been trying to get all the instructions in the following links to work with no success: https://community.denodo.com/answers/question/details?questionId=9060g000000Xf4oAAC&title=OneDrive+Connetion https://community.denodo...

Answers: 4

Datasource OneDrive Excel CSV Sharepoint

Connect Denodo to OneDrive/Sharepoint Excel files
answered 21-05-2020 08:20:51 -0400

Dear Gurus! I've tried to follow all the KB manuals, yet the instructions are not very clear as I'm not familiar at all with API terminology or protocols. Also Microsoft changed their way to register an application client https://docs.microsoft.com/en...

Answers: 3

OneDrive Excel Sharepoint