Stack Overflow
Stack Overflow

Questions tagged [datanitro]

DataNitro integrates Python with Excel.

DataNitro integrates Python with Excel. It's used by finance professionals, data analysts, and Excel power users to improve data input, processing, and analysis.

https://datanitro.com/

59 questions
228
votes
4 answers

converting list of header and row lists into pandas DataFrame

I am reading contents of a spreadsheet into pandas. DataNitro has a method that returns a rectangular selection of cells as a list of lists. So table = Cell("A1").table gives table = [['Heading1', 'Heading2'], [1 , 2], [3, 4]] headers =…
Joop
  • 7,840
  • 9
  • 43
  • 58
6
votes
1 answer

does datanitro stop working after 30 days?

First of all, I have to say datanitro is awesome. I am thinking of using it for non-commercial use. According to the website, it is free for non-commercial use. But all I can do is download the 30 day trial version. On excel, it says 30 days left.…
linuS
  • 171
  • 1
  • 8
5
votes
1 answer

Writing a 2-D array to Excel

Is there a good way to write a 2-D array to a table in DataNitro? I'm working on a basic sudoku solver in Excel and would rather use python than VisualBasic.
brettcvz
  • 2,371
  • 1
  • 13
  • 14
4
votes
1 answer

Using Python (and DataNitro) to copy cells from a particular sheet in one Excel workbook, to a particular sheet in another Excel workbook

I do a lot of data analysis in Excel and have been exploring Python and DataNitro to streamline my workflow. I specifically am trying to copy certain cells from one sheet in one Excel workbook, and paste them into certain cells in a certain sheet…
Ucla2017student
  • 41
  • 1
4
votes
2 answers

Python shell issue when using Data Nitro

I am using DataNitro to write Python Script in Excel. Its very useful indeed. However, when I open the Idle editor in excel, the accompanying Python Shell is not interactive, in that it does not return print statements, show errors, nothing. It just…
Woody Pride
  • 13,539
  • 9
  • 48
  • 62
3
votes
0 answers

How to print Chinese Characters in DataNitro?

I am new to DataNitro. I want to deal with some Chinese Characters in my excel sheet but fail. When I print Chinese Characters in Python Shell, everything is right. However, when I print Chinese Characters in an imported python file, it tells me…
user3847025
  • 33
  • 3
3
votes
1 answer

Reading Excel Cell Value directly to complex Python Obects, DataNitro

I am working on a program that allows me to perform diagnostics and extract data from files that contain hundreds of excel sheets. I am using the DataNitro add in. My program has two phases: PhaseI: The diagnostic: the program reads every cell in…
Woody Pride
  • 13,539
  • 9
  • 48
  • 62
2
votes
1 answer

Datanitro Charts

How do I control the position of a chart on the Excel sheet using Datanitro? I thought that by setting the active cell it would be positioned there but it always comes out as top left where it obscures cells with calculated results that I want to…
mcgerard
  • 33
  • 4
2
votes
1 answer

DataNitro - copying from the shell into an editor

I'm using DataNitro and would like to be able to copy output from the Excel Shell and paste into my editor. However, I can't find a way to do that. Any idea how I might do that?
CafeDude
  • 41
  • 2
2
votes
1 answer

DataNitro - get selected Cell / Range

I am writing an Excel Macro that parses a user's selection and uses the data to create a SQL database table. I'm using DataNitro to fire off the scripts straight from Excel, but need help feeding the Excel selected values into my python script. I…
Jonathan
  • 21
  • 1
2
votes
3 answers

Data Nitro and regular expression (Python)

I have this column in MS Excel 2010 - which has a combination of 'zip code' and 'email-ids' I am trying to extract these zip-codes(20530, 90012-3308 etc.) from this column. 20530 mark@ucvxcx.gov 20530 kidafd@gmail.com 20530…
hky404
  • 1,039
  • 3
  • 17
  • 35
2
votes
1 answer

Copy Sheets with xlrd/xlutils

I have a folder with many excel files of the same format, with multiple sheets. The goal is to loop through the folder and move one of the sheets in each notebook to an new notebook i.e. ending up one sheet from each .xlsx file in the new workbook.…
Woody Pride
  • 13,539
  • 9
  • 48
  • 62
2
votes
1 answer

DataNitro autoformats dates

I am using DataNitro in my spreadsheet. When I write the values to a cell. It automatically guesses if format looks like a date. This is obviously not always helpfull! dt_str = "08/20/13" Cell("A1").value = dt_str # puts date type in that…
Joop
  • 7,840
  • 9
  • 43
  • 58
2
votes
1 answer

UnicodeEncodeError in DataNitro, excel

I was trying to run a python script through DataNitro in excel by importing the script and then pressing the runn button. I got this errormessage: Traceback (most recent call last): File "27/scriptStarter.py",line 97,in…
graadiggrei
  • 35
  • 4
2
votes
2 answers

MySQL not accepting executemany() INSERT, running Python from Excel (datanitro)

I HAVE ADDED MY OWN ANSWER THAT WORKS BUT OPEN TO IMPROVEMENTS After seeing a project at datanitro. I took on getting a connection to MySQL (they use SQLite) and I was able to import a small test table into Excel from MySQL. Inserting new updated…
Shane
  • 1,629
  • 3
  • 23
  • 50
1
2 3 4