-
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.
-
import password protected files
How can Dataiku import and read password protected Excel files?
-
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?
-
How do I view and select specific sheets from multiple Excel workbooks uploaded in DSS project?
I have loaded multiple Excel files, each with multiple sheets and need to select two sheets to work with from each file. Currently I am only able to see a sample from the first sheets but those are not the sheets that I need to work with.
-
Export in Excel format
Hello, Since the upgrade to version 5.0, i cannot export my files in the excel format. (CSV is available but not Excel) It was available before the upgrade. What can be the reasons ? Thank you for your answer. Binh
-
Excel (xlsx) with multiple sheets
Hi, So I've been trying to fetch a public dataset that is imported as a .xlsx file. This file is properly loaded on the first sheet, but contains 3 sheets in total. Now somewhere at the bottom of the HTTP dataset overview is a ""Select sheets" which contains some Angular tags. It seems to be either a bugged or not fully…
-
Force text type in Excel export
Bonjour, I am trying to export a file with a column of IDs, that Excel interprets as number (even if the type is string / Text in Dataiku). e.g. -2.876553E16 --> 25561367.87 (Excel believes it is an exponential) e.g. some #DIV/0! occurs also How can I force this column to stay in text when I export ? Thank you ! Pierre PS:…
