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
1
vote
1 answer

DataNitro - Cannot Import nitroplot in functions.py

I want to import nitroplot in the functions.py to create a custom plot. I cannot seem to do this and keeps on getting error: {'type': 'error', 'value': 'Traceback (most recent call last):\n File "27/NitroFileManager.py", line 110, in…
Tooblippe
  • 3,433
  • 3
  • 17
  • 25
1
vote
2 answers

Data Nitro error attempting to copy row

I am trying to check against two value in a row, if that check passes then I want to copy the entire row at the end of the sheet. LAST_ROW = 4488 CURRENT_ROW = 3 NEW_ROW = LAST_ROW + 2 while CURRENT_ROW <= LAST_ROW: if Cell(CURRENT_ROW,…
Flexo1515
  • 1,007
  • 1
  • 10
  • 27
1
vote
0 answers

Python under Excel is slower. Why?

We are embedding Python inside our application. Our application has number of client interfaces, including the Excel and command line tool. At startup our aplication might read (depending on some parameters) large number of Python files. And here is…
Gennadiy Rozental
  • 1,905
  • 2
  • 13
  • 17
1
vote
1 answer

DataFrame Column with missing values won't accept input

I'm reading a csv file into a data frame, and then using data nitro to allow users to modify the data based on inputs in excel cells. This works fine except it seems when every value in a df column is NaN. The first step is for the user to enter the…
Woody Pride
  • 13,539
  • 9
  • 48
  • 62
1
vote
0 answers

Datanitro raises "Failed to connect/bind"

I just installed datanitro but I keep getting the following error when I try to open a shell: Failed to connect/bind ... This msg also raises when I try to execute a script. Can someone point me in the right direction? Thanks!
SPAZ
  • 11
  • 2
1
vote
2 answers

Converting time with Python and DataNitro in Excel

I have a list of times in h:m format in an Excel spreadsheet, and I'm trying to do some manipulation with DataNitro but it doesn't seem to like the way Excel formats times. For example, in Excel the time 8:32 is actually just the decimal number…
user1104854
  • 2,137
  • 12
  • 51
  • 74
0
votes
1 answer

How can I specify a CellRange of variable length in DataNitro?

I am creating a script and part of it requires a list of names from a cell range to be stored as a list. I need the list to store as many names as are added to the cellrange however it must not store the values of empty cells. If I simply use a…
Louis Falconer-Flavin
  • 3
  • 6
0
votes
1 answer

Getting ASK price on Bloomberg using Python API

I am trying to get the ASK price from Bloomberg using Excel's DataNitro. I am calling this function from excel: main() def main(): options = parseCmdLine() # Fill SessionOptions sessionOptions = blpapi.SessionOptions() …
Jane Doe
  • 21
  • 6
0
votes
1 answer

Is there a version of DataNitro for Excel that uses Python 3.5?

Is there a version of DataNitro for Excel that uses Python 3.5? I noticed the trial version uses (and installs) Python version 2.7.9. I've been using Python 3.5 for all of my new Python projects and I'm not really too keen on having yet another…
Versalytics
  • 23
  • 6
0
votes
1 answer

Waiting for DataNitro to finish in a VBA call

I am calling a python script from VBA with the following: Sub python_call() Application.COMAddIns("DataNitro.DataNitro").Object.RunScript ("test.py") 'do some other stuff End Sub test.py takes a while to run so I want VBA to wait before running the…
ayhan
  • 70,170
  • 20
  • 182
  • 203
0
votes
0 answers

Using Datanitro and Python to match values in separate rows

I will begin my question by warning that I am an absolute and complete novice with Python, I am attempting to to create a map with NSF Grant amounts and the Congressional district those grants were received in. In order to do this, I need to first…
Eric Ralph
  • 1
0
votes
0 answers

Data Nitro and Fuzzy Logic

I am trying to do fuzzy logic on an Excel spreadsheet for two data sources exported from Microsoft CRM. One is Account data, and the other one is Lead's data. Account Sheet contains - All the existing customers. Lead's Sheet is a 'dirty sheet' and…
hky404
  • 1,039
  • 3
  • 17
  • 35
0
votes
1 answer

Mining pdf Data with python through clipboard - Python Scripting the OS

I have written a script that extracts data from pdf. I am using the win32clipboard module to copy the the data into python. Got the logic working on how to get the data I need in each file. The shortcoming of my process is that I have to open…
Joop
  • 7,840
  • 9
  • 43
  • 58
-2
votes
1 answer

Find a string in list of strings, write table in Excel with Datanitro

My worksheet "FX" has 22903 rows and 1 column ("A"). I want to iterate through all lines, find the one that has EC CME EURO FX FUTURES and write the three lines below to row 1, column "B" of the "FX" spread sheet. I'm using Datanitro and the shell…
Theseus
  • 1
  • 1
1 2 3
4