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
2
votes
2 answers

How to save an excel file with DataNitro and python

I've got an python script to that generates an excel worksheet from a database query with the DataNitro excel plugin (the free one), now i want so save the file and then send it via email, but the DataNitro docs only includes working with cells and…
loki
  • 2,271
  • 5
  • 32
  • 46
1
vote
1 answer

How to zip values into a table with uneven lists? (DataNitro)

I'm attempting to get the last 5 orders from currency exchanges through their respective JSON API. Everything is working except for the fact there are some coins that have less than 5 orders (ask/bid) which causes some errors in the table write to…
Carl Sandburg
  • 46
  • 1
  • 6
1
vote
1 answer

Using DataNitro, how do I print a python loop to excel, making sure that after 23 rows are printed, printing moves to the adjacent column?

I am using grequest to pull json data from multiple urls. With the help of another user here, I was able to get python to print the results from each url in succession. Now, I want to print those results to excel using DataNitro. Here is the code I…
Jim Carlson
  • 51
  • 9
1
vote
0 answers

Datanitro - Create a sheet that has data validation in it?

I have one sheet (let's call it sheet1) that has a range of cells A1 to A20 filled. My python script is going to create a new sheet (sheet2) and fill in a few cells. The user then enters in a few other new cells, say B2 to B4. I want those cells…
Doug Smith
  • 500
  • 7
  • 21
1
vote
1 answer

Datanitro failed to find Python

I have previously used Datanitro with Python 2.7. Now after a break when I have probably forgotten half of what I knew, I thought I would start to use Python 3. Python 3.5.2 is installed in C:\Program Files (x86)\Python35-32\ In DataNitro settings,…
mcgerard
  • 33
  • 4
1
vote
1 answer

User Defined Array formulas in DataNitro

I have created a python function to exponentiate a matrix and imported it as a user defined function in Excel using DataNitro. However, when I use this formula I get the result as a python list in one cell. Is it possible to create array formulas…
Kaustav Sen
  • 113
  • 2
1
vote
1 answer

Can't find pandas in data nitro

when I try to import pandas using the data nitro shell, I get the error that there is no module named pandas. I have pandas through the canopy distribution, but somehow the data nitro shell isn't "finding" it. I suspect this has to do with the…
CafeDude
  • 41
  • 2
1
vote
1 answer

datanitro - pass variables from one script to others

Is there a way to have a variable (resulting from one script) accessible to other scripts while Excel is running? I have tried from script1 import df but it runs script1 again to produce df. I have a script that runs when I first open the workbook…
ayhan
  • 70,170
  • 20
  • 182
  • 203
1
vote
0 answers

Datanitro insert Images

How do I control the position and size of an image on the Excel sheet using Datanitro? I want to insert and resize an image and change the position by setting the active cell. First, I need to insert several images and I change the position using…
luis Rafael
  • 11
  • 2
1
vote
1 answer

Sorting Excel Range with Datanitro

I am trying to sort a range of cells in excel using Datanitro. It doesn't look like Datanitro has a built-in sort method, so my options are to either create one in python, which is what datanitro appears to have done here, or use the built-in VBA…
DFT
  • 65
  • 4
1
vote
0 answers

Receiving Type Error: 0 while updating pandas df using Data Nitro

I am updating a Pandas Data Frame. The script looks up for a product. If the product is already in data frame, it just updates it columns with accumulated new values. If the product is not there it creates a new set of rows to insert the values of…
SDS
  • 43
  • 1
  • 6
1
vote
1 answer

Can I integrate Datanitro into an executable?

I'm looking to be able to create an executable with py2exe or something similar that takes information from an excel sheet and returns a word file. Since my coworkers are technically challenged, I need to create an executable that will take the work…
jh44tx
  • 119
  • 9
1
vote
1 answer

Is it possible to add borders to an excel range automatically by using datanitro?

Is it possible to add borders to an excel range automatically by using datanitro? i.e. something like: >>> CellRange("A1:A5").upper_border= True
CafeDude
  • 41
  • 2
1
vote
1 answer

Datanitro python script not executing in workbook_open()

In ThisWorkbook Excel Object I have the following two subroutines: Private Sub Workbook_Open() MsgBox "Hello World" Call call_DN End Sub Sub call_DN() Application.COMAddIns("DataNitro.DataNitro").Object.RunScript ("test.py") …
DFT
  • 65
  • 4
1
vote
1 answer

How can I avoid dntypes.ExcelErrorName()

In my spreadsheet I have cells that contain a string such as =some string here Excel displays this cell as below if formatting as general. This makes sense because Excel is trying to calculate a cell with a function that doesn't…
canyon289
  • 3,355
  • 4
  • 33
  • 41
1
2
3 4