Questions tagged [microsoft-excel]

For recommendations for software that interoperates with the Microsoft Excel spreadsheet software.

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

Tool to connect Excel VBA macro to IBM AS/400 Access Client

I am working with data in excel and IBM AS/400 Access Client. they linked together using vba macro. However, recently my company wants to change to IBM AS/400 Access Client Solution which is the ...
-1
votes
2answers
16 views

Convert CSV file to another layout

I would like to change the layout of a input CSV file and change the layout of values. So the initial Format has headings like: - Customer Zone Type 1 2 3 4 5 6 7 8 9 10 11 12 Under the number ...
-1
votes
0answers
5 views

Deploy Dash App with a backend Excel engine [closed]

I am developing a Dash app which uses an Excel file in the back-end to perform some calculations. I need to deploy this Dash Web app. I need help with a way to do this.
0
votes
1answer
7 views

convert space-delimited txt file to tab-delimited excel [closed]

I have a space-delimited file that looks like this while opening in notepad and this in excel. How can I convert this file to a tab-delimited file in excel where each column shows a category?Thanks!
0
votes
0answers
26 views

Line Graphing from dynamic excel data

I have been developing a tool that processes timetable data and would like some advice on how to develop the graphical output. I do intend to keep the data in excel, but would like to output to a ...
0
votes
0answers
7 views

Cricket Scorecard in Excel

Is it possible to create a cricket score card in excel like the way in an app. like when user enter what happens in one ball, say the striker takes a single, when I enter one in a cell, it ...
0
votes
1answer
9 views

How can I programmatically insert an image in to an excel file?

I have a folder with an excel file and an image. Which programming language can I use to insert the image to a cell programmatically? The files are located on a Linux server running a strictly ...
0
votes
0answers
6 views

SSIS Excel (.xlsx) Connector to SQL Server 2012/2016 recommendations?

Any recommendations on 3rd party Excel Source/Destination Connectors for SSIS to SQL Server 2012/16? What are the kinks? I really can't find reviews on these things anywhere. We need something ...
0
votes
0answers
5 views

repeat cell references in formula in Excel

How can I repeat a range of cells referenced in a formula in excel? for example I want to have AVERAGE(A1,B1)/STDEV.S(A1,B1) I want the 2nd reference(A1,B1) linked with the 1st one so that when one is ...
1
vote
0answers
7 views

What program would you use to do simple querying on tabular data?

I often receive data in Excel files and want to some simple lookups the way I would with SQL. In Excel, doing something like select b.field from a join b on a.a1 = b.a1 and a.a2 = b.a2; is doable with ...
-2
votes
0answers
7 views

complex vlookup function

I would like to recuperate the values of a table when are corresponding to particular data. Practically in the image attached, I have a table where for some date I have multiple values for SEB. I ...
0
votes
0answers
15 views

Running an Excel Macro on a Windows Server

I have an Excel Macro running on my local machine everyday at 6:00 AM using Task Scheduler that does the following: Macro opens a couple of other Excel Files that are connecting to a SAP Cube via ...
1
vote
0answers
13 views

C# Library for manipulating Excel Files?

I'm working on a project to migrate excel data into new excel files that are compatible with another system. As part of this work, I have to do a lot of data manipulation between excel sheets (...
0
votes
0answers
10 views

Automatically move row in excel based on date [closed]

I have an excel file that with a product includes release dates, if the date has not yet occurred (Next week, next month) - I'd like to automatically move it from its section (Let's say A1 to A5) and ...
0
votes
0answers
9 views

What software should I use to build an app that can communicate with SharePoint?

I'm trying to build an app where the user can draw with their finger and have the drawing be placed in an Excel file which is sent to SharePoint. It can either be an android or web application. I ...
-1
votes
0answers
2 views

Is there a way to process an excel file when uploading to Django and returning a finished output?

I have a code for processing a specific excel file. It uses pandas, numpy, openpyxl, and some matplotlib. My goal is to run this code when the excel file is uploaded through the django frontend. The ...
0
votes
0answers
3 views

Library to create and write line charts to Excel workbook in Python

I need to make about 30 line charts, preferably somehow within a for loop. They would need to be created within a sheet within an Excel workbook and saved there. I've been using openpyxl for parsing ...
-1
votes
0answers
8 views

Excel Cryptation tools or add-on

Is there any possibility to have a cryptation on excel? Some kind of an Add-on or Software to crypt Excel Files? Not Signature
0
votes
0answers
4 views

Need software recommendation to fetch data from a URL

I am trying to fetch store name and cashback percentage from this website using google sheet's importxml function. Put following commands with no success. Please help =importxml("https://www....
-1
votes
0answers
5 views

Tool to import data from disparate unstructured PDF and Excel documents, into Python Jupyter notebook

I'm not interested in invoicing/reporting automation software. What I'm currently trying to do is applying machine learning tools to automate a lot of manual financial analysis works at my company. We ...
0
votes
1answer
12 views

Compare two excel sheets

csv spreadsheets with the following data: Sheet 1: ID Name Address City PostalCode Phone Sheet 2: ID Name Address City PostalCode Phone I would like to compare the two sheets for added rows, ...
1
vote
1answer
6 views

Converter for Microsoft Office XML to OOXML (Office Open XML)?

We have some software producing a spreadsheet in the Microsoft Office XML file format (introduced in Office XP) and would like to convert this to the newer OOXML format that has been used with Office ...
-1
votes
0answers
5 views

How to connect to a remote file using CData Excel JDBC driver?

Using CDATA to connect to local excel file with jdbc url below: Connection conn = DriverManager.getConnection("jdbc:excel:Excel File=C:\MyExcelWorkbooks\SampleWorkbook.xlsx;"); Can we connect to a ...
0
votes
0answers
11 views

RStudio or SQL for data cleaning

I am wanting to detect corrupt and inaccurate records to check for data quality from large data sets that originate from Microsoft Access and Excel. Things I would like to check for: Validity which ...
0
votes
0answers
7 views

Free, multi-user searchable list with categories

I have been asked to create a "searchable" list of referral sources that could be: Updated and accessed by multiple people Easily searched The team I'm with hates Access. None are very tech savvy. ...
0
votes
0answers
5 views

Getting data in .xlsx format, trim it online, and send it by email

I am looking for some software that is able to get a file in xlsx format, so we can trim that data (automatically, possibly online, twice a month) and resend it to an email address. Is there ...
0
votes
0answers
3 views

Easy to use WIndows tool to view HDF5 files and/or convert to CSV

I tried using HDFView (https://www.hdfgroup.org/downloads/hdfview/ ), but it doesn't display the columns clearly. It groups all data columns into an array and removes the column headings when I try ...
0
votes
0answers
5 views

Pre-Translation Microsoft Excel using online APIs from a language to another

I'm looking for any solution to pre-translate values from one language to another one in my Excel Worksheets using any free translation API (Google, Yandex, Microsoft...) The goal is to minimize user ...
0
votes
0answers
6 views

Microsoft Word and Excel

I'm looking for a light and simple alternative to Microsoft Word. I would like an application that can run on IOS10 and also mobile applicability on the go for editing.
0
votes
0answers
10 views

Software for barcode registry

I have a fruit harvesting business that I would like to find existing, or implement software to keep a registry of scanned bin barcodes for each day, per team, and block area of an orchard. Any given ...
0
votes
0answers
14 views

Android app for quick data notes

I am looking for an Android app in which I can quickly input numbers on standard sheets, without always switching on the touch keyboard. I'll explain a little further. I periodically go to some shops ...
1
vote
0answers
5 views

Software for 3D Processing

I have a project for my work which requires me to take XYZ data from a CSV/Excel file using this data I need to generate a 3D line/spline then using this I need to render small segments of a pipe ...
1
vote
0answers
12 views

Connect Excel to HDFS and update data real time

I am trying to figure out a method or software for updating data into HDFS real time. My requirement is as follows: I will have an Excel in a server. That Excel data needs to be loaded into HDFS. IF ...
1
vote
0answers
12 views

Software to connect Apache Derby DB with Excel

I would like to use a Apache Derby database as source for an Excel file so that I can use the tables and manipulate them in Excel. I have tried to connect the Derby DB with the Derby ODBC Driver ...
0
votes
0answers
11 views

COTS EDI software to view an XSD in Excel

Which commercial off-the-shelf software offers a feature to make an EDI data mapping specification for remote programmers based upon an XSD file? The remote programmer will not have access to the COTS ...
1
vote
0answers
5 views

Software to annotate PDF from Excel or Python

I have a large PDF files. Each PDF page contains a chart and also includes a unique identifier, i.e. chart number. I have individual comments for each chart and would like to insert these in the ...
1
vote
0answers
10 views

Automate the process of running an excel macro on Sharepoint

Is there any way to automate the process of running an excel macro from an excel file in SharePoint without having to do it manually every day? From my understanding, Sharepoint does not have this ...
0
votes
1answer
13 views

Where can I find some fun Excel sample data to download?

Are there any web applications out there that offer free Excel sample data utilizing fun topics like perhaps Star Wars characters?
1
vote
2answers
33 views

What database can be periodically exported to a sheet of an Excel file? [closed]

I'm developing a web-scraping tool by Python for my own use. I will run regularly the Python program to write data to a database. I hope with not too much manipulation/script we can export data from ...
1
vote
0answers
13 views

Framework for editing, uploading, saving Excel in React

I'm using React and I need a library and by using it I want to upload an excel from the computer (I'm doing it with react-dropzone), edit it in the browser and can save the edited version to the ...
0
votes
1answer
31 views

Is there a text editor which displays column numbers and/or displays text in a grid to quickly glance column numbers?

I basically need a text editor which displays text in a grid, so that I can know the exact column numbers of the text. The numerical simulation software I am using, TOUGH+ (written in FORTRAN), has a ...
1
vote
2answers
35 views

What is the recommended software platform to develop web based financial calculators

We are looking for recommendations on the best open source software platforms to develop financial applications. The platform should be able to accurately & quickly calculate calculators such as ...
1
vote
1answer
18 views

Library to modify Excel in Python

I love to use Python, but I also found C# and VBA as options. I want to read one Excel file, then search another Excel file (with multiple sheets), and use this information to modify the initial ...
0
votes
0answers
5 views

iPhone app to open a spreadsheet, click on the client's number and dial it directly from the data sheet

I use MS Excel at work for various client contact databases. I use Dropbox/Google Drive so that I can access the data from anywhere using my iPhone. I would like to be able to use my iPhone X to open ...
2
votes
1answer
22 views

Ingesting word documents into internal systems [closed]

Current Problem: We have a vendor that provides us with a bill of lading in the form of a word document via email, and we are looking to ingest this information into our SQL Server database. I've done ...
3
votes
0answers
23 views

Python IDE with parameter hints

I want a python IDE that shows function arguments as does Excel. Example: In Excel, I can type "=IF" and the formula will show what arguments, in which sequence, Excel wants to finish the function. ...
1
vote
1answer
12 views

SalesForce and Excel - Chrome Extension the Best Solution?

I work with a sales team who frequently enter OPPs into SalesForce. Part of this process requires the sales rep to manually: Google customer City+State to find Zip Codes Use an in-house spreadsheet ...
0
votes
1answer
14 views

Program wanted to analyse/send/combine reports and feedback

My main job at my company is to analyse reports. I receive them in an csv file, with additional information such as, who sent them and from where. My normal workflow is to read the reports, create a ...
0
votes
0answers
61 views

Which JavaScript Library use to generate complex psychrometric chart to replace excel

I am trying to get some recommendation, advice how to replace my current process where I use local macro excel with JS to reproduce Psychrometric Chart. I have macros in excel with calculation that I ...
0
votes
1answer
33 views

Reverse Email Address Lookup and Email Validation

What is the best site or tool to do email address validation or a reverse lookup for the name attached to that email. I am working in a database for a company and they need to verify who their leads ...