-
Coloring / highlighting rows and exporting in Excel
Hello, It would be nice to have a plugin that allows to color rows based on a formula or criteria, and to have the color / highlight kept when exporting to an Excel file. Best regards.
-
Uploading multiple sheets/files at once
Hi, I am trying to upload multiple excel files with multiple sheets at the same time into one dataset. Is it possible to add a special column indicating the original dataset (excel file + sheet)? Many thanks
-
Error loading XLSX file from Google Drive because "not a valid OOXML" - Google Drive Plugin
Hello, I am using the Google Drive Plugin (version 1.1.4) with which I'd like to load an .xlsx file from a Google Drive using a service account. However, I get the following error: "Failed to open Excel file, caused by: NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open…
-
Establish a dynamic connection between a dataset in Dataiku and Excel
I would like to be able to create a dynamic connection between a dataset in Dataiku and Excel, so that any changes in Dataiku would be automatically refreshed in an Excel file. There is a plugin available that connects Dataiku and Power BI dynamically. Please see the link below: Plugin: Microsoft Power BI | Dataiku My…
-
import password protected files
How can Dataiku import and read password protected Excel files?
-
Is there a way to automate distribution of a Multi-sheet Excel Export spreadsheet?
From the scenarios section, the Excel spreadsheet created by the Multi-sheet Excel Export plug-in does not appear as a file to attach, though the three tables that went into building the spreadsheet are. Is this a case of a choice between either downloading the spreadsheet independently to be distributed manually, or…
-
Export multiple datasets into one single excel file with multiple sheets
Hi All, I am trying to export different processed datasets ( for example dataset1 and dataset2) into one single excel file with multiple work sheets ( sheet 1 containing dataset1 and sheet 2 containing dataset2). Is this possible?
-
Import xlsb
Hello, How can you upload an Excel stored in binary format in Dataiku ? Thank you !
-
Create a Dataset from an excel file in Python recipe
Hi, I am having trouble when creating a Dataset from an excel file. I am using the Rest API client in a Python recipe. I've suceeded in doing so from a csv file with this code : client = dataiku.api_client() project = client.get_project('******') folder_path = '/Users/dmer/Desktop/*****/' for file in…
-
Who can help me fix an error I get everytime I try to export into excel?