Q&A BY TAG 'EXCEL'
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
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
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
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
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
how to use excel microsoft query to do some aggregation function on one denodo views?
answered
25-11-2019 13:10:19 -0500
I have configured 32-bit ODBC, and let my excel connect denodo views. I can pull the data from denodo to excel in detail level, how do I use microsoft query to do some aggregation caculation on some view. For example, denodo view_a (contain column mont...
Answers:
3
Microsoft Query (Excel) not Compatible to Denodo Query
answered
05-11-2019 12:41:13 -0500
Hi team, I used excel to connect denodo for views data visualization, I follow this link: https://community.denodo.com/tutorials/browse/basics/4connect2odbcclient . And it works. However, when I want to do some advanced query, not only get the detail...
Answers:
3
HTTP client
answered
24-04-2019 13:38:18 -0400
Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a MS Excel HTTP client example to practice. Thanks.
Answers:
3
Start and End Cell Behavior in DenExp 7.0
answered
14-12-2018 07:28:48 -0500
Hi Team, Denodo 7.0 Express MS Excel 2010 Format .xlsx Id Name Age City 1 ABC London 2 PQR 20 Sydney 3 LMN 30 Munich 4 XYZ 40 Paris If I chose Start Cell as B1 and End Cell as D4. I get below result: Name Age ABCPQR 20LMN 30 XYZ 40 Why is city colu...
Answers:
1
source file info
answered
07-08-2018 15:14:16 -0400
Hi, I found some interesting predefined stored procedures here, but as far as I've seen, they don't deliver output I'm looking for: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_sto...
Answers:
3