The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [microsoft-excel]

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

77 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
1answer
250 views

Software library or tool to pivot and export a lot of data to Excel

I'm trying to find a way to get normalized data that's in an MSSQL database out of there, pivoted, and into an Excel file. The main problem is that I have many of those databases, each with the same ...
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. ...
3
votes
0answers
39 views

Excel to SQL mapping tool

I am looking for a tool/library to import data from different clients into our SQL database. Each client will have their own EXCEL file. So the number of columns, name of the columns in EXCEL would be ...
3
votes
0answers
163 views

PDF to Excel (xlsx) conversion

I am in need of software (Not online service) that can convert my PDF documents to Excel accurately. I have tried Adobe Acrobat Pro DC and Nitro, they are great at the conversion, but I cannot ...
3
votes
2answers
511 views

Anyone know of any other alternatives to Edraw Office Viewer Component or Office Components?

I want the ability to load excel workbook into a windows application form and have all the features excel have if you were to open it by itself. Edraw https://www.edrawsoft.com/officeviewer.php seems ...
3
votes
0answers
30 views

What software can be used to create logic from datasets?

I need a software that can import a dataset (excel/CSV table) and I can write formulas/create a workflow logic to export into another (excel/CSV) table. I need this software to be able to be deployed ...
2
votes
4answers
104 views

Multi-user data editing software (think Excel/Access) with chart support?

I have a client (large corporation) with a broken Excel document where their staff enter some numbers, which are then displayed in some charts (like a sales dashboard). There is some validation on the ...
2
votes
0answers
119 views

Graphing or charting library that approximates Excel's capabilities?

Moved here from SO, please inform me if need to move elsewhere again. Here's the post: I've been using Excel to manually plot data from CSV to timeseries charts and histograms (with cumulative ...
2
votes
0answers
263 views

Convert Excel to GeoJson in Java

I'm looking for a way to convert an Excel file to a GeoJson file, I looked at GeoTools, found an gt-excel plugin, but I couldn't get it through Maven to try it out. Is there another way ? edit The ...
1
vote
0answers
22 views

Best Tool for Analyzing Multi-Tab Excel Files with 100-500k Records

I have started a new job and I need to analyze client's databases. Many times when we first meet with them we just get a huge Excel file with a dozen or so tabs and a partial to full dump of various ...
1
vote
0answers
7 views

Mapping Application for Excel

I'm not sure if this is the right place to ask this question but I need to map around 20 truck routes that are listed in excel. I would like to plot each stop as a point on a city map, and then draw a ...
1
vote
0answers
7 views

How to manipulate Excel with python

I would like to perform some operations on an existing excel files which already contains some datas and formulas. It contains also charts. The operations that I would like to do are adding some ...
1
vote
0answers
8 views

Which programming language works with tables and databases, considering reports and GUI?

I’ve been working with VBA previously but i want to learn other programming language, having a project in place I would like to know which language to pick and start learning… This project is based in ...
1
vote
0answers
10 views

Library to develop web-based spreadsheet, compatible with Excel and PDF

I'm looking for open source library's which can make own web editor for editing excel sheets like Google Spread sheet. I want webify the excel sheet & Pdf as web application. Are there any Open ...
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 ...
1
vote
1answer
19 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 (...
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
13 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
17 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 ...
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
11 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 ...
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 ...
1
vote
1answer
14 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 ...
1
vote
0answers
112 views

Cross-platform Excel library for C++ that can calculate formulas

I am looking for a C++ library to read and write excel files (xls and xlsx formats) for an application running on Windows and Mac. libXL nearly fits the bill, except I also need it to calculate ...
1
vote
0answers
40 views

multiple Json to excel and vice versa

The application I'm looking for must be web based or even better if it run on linux 64 bit, I have fedora Must be free Must support UTF8, because of arabic strings Suppose you're building a multi ...
1
vote
0answers
26 views

Tool to work with embedded Excel spreadsheets in .NET Core

I am working on a project which receives an .xls from a service which then needs to be displayed in a web app. This web app needs to be written in .NET Core, so not necessarily any Excel manipulation ...
1
vote
1answer
242 views

Excel to CSV Java library

I am looking for a Java library (preferably in Maven Central) that can read XLS and XLSX and save the sheet to CSV. I am looking for something higher level than poi and jxl as neither of these have ...
1
vote
0answers
189 views

Tools to reverse-engineer an Excel spreadsheet

I have at various times been asked to improve some predictive model whose only implementation and documentation is an Excel spreadsheet. What I want instead is a concise set of equations describing ...
1
vote
0answers
305 views

Web application create Excel like grid and store in database

Web application create Excel like grid and store in database I'm looking at a project that will emulate the functions of a Excel worksheet so that an end user can specify cells and headings and what ...
1
vote
0answers
216 views

Printing XLS file programmatically without Excel installed

I have a VB6 application that produces and prints .xls files thanks to an old and deprecated component. It isn't compatible with some of the new printers drivers (makes my application freeze and crash ...
1
vote
0answers
33 views

What is a software for logic and rules management?

I have developed an app that imports excel tables in a specific format and performs analysis on the data. I need to find a software that can Take other excel/csv files and implement database logic ...
1
vote
0answers
238 views

Testing pdf/excel content with C#

Our site has a good number of reports that are using SSRS,Crystal and Excel. We are using C# with Selenium WebDriver. I have been searching for the best practices and best ways and tools to test the ...
1
vote
0answers
185 views

C# library for Windows store apps, to display .ppt .xls

Im searching for a library that allows the viewing of powerpoint files(.ppt) and Excel files(.xls) is there anything of sorts in windows store apps?
1
vote
0answers
39 views

Exporting all charts from a Microsoft Excel 2013 file as PDFs

I am looking for a program that can export all charts from a Microsoft Excel 2013 file as PDF files. If possible, free, can take a batch of files as input, crop out the surrounding white space and ...
1
vote
0answers
72 views

Is there a Microsoft Excel automated (or interactive) “VLOOKUP” program or SaaS where I can combine 2 excel sheets?

I have 2 sheets and I know to use VLOOKUP to cross-reference the sheets and join the data into one sheet. I am wondering if there is an application for windows, or an online SaaS that allows you to ...
0
votes
0answers
8 views

How to handle a very large CSV file

The authors of a paper on migrating birds have made public a CSV file which has about 707,000 rows. These represent the flight path coordinates of 707 flights made by individual birds. I want to ...
0
votes
0answers
2 views

Intelligently identifying and analyzing tabular data in Excel spreadsheet

Our company is building an online system that needs to accept Excel files as part of the registration process of our service. Our system will only be interested to consume what looks like columns and ...
0
votes
1answer
16 views

How to import table data from excel into Azure FROM LINUX

I'm in a database management class and the professor strictly teaches toward windows machines, so she uses Microsoft SQL Management Studio to interface with our databases. I have a linux machine, so I ...
0
votes
0answers
6 views

Machine learning in data extraction

Are there any tools that have “self leaning and auto transformation” capability whereby we can interrogate a client-provided file in it’s native format, identify key data elements, and pull pertinent ...
0
votes
0answers
4 views

Tools that can do AI based document-data-extraction

I have a requirement for an “auto transformation” capability whereby we can interrogate a client-provided file in it’s native format, identify key data elements, and pull pertinent content into a ...
0
votes
0answers
15 views

Help developing a golf score tracking mobile application

I, along with three other people, are assigned a project for our upper-level college course. We are responsible for creating a mobile application for our schools golf team. Here are the specifications ...
0
votes
0answers
14 views

Generalized Excel VBA tool to run SAP reports and save output

My team often needs to extract data from the SAP R3 GUI into a file format such as Excel. We have been using VBA scripting to do this, using the approach described in https://stackoverflow.com/...
0
votes
2answers
11 views

VBA in Excel vs Access for data conversion

We are upgrading our enterprise software and part of that effort I have to perform sales order (data) conversion from legacy to new software. I have moderate experience with macros/VBA in excel and I ...
0
votes
0answers
9 views

Software for backing-up my phone text messages into php/excel

Does any one know an android software or web application for converting phone text messages into sql/excel. Its only for representation purposes and i think i can use them in the future.
0
votes
0answers
8 views

Suggestion for an open source to be used as UI and to consolidate data into Excel Spreadsheet

We have a table in MS Excel, where different users enter into different rows of data. All the data is collected and consolidated into the same sheet. Kindly suggest a web-based open-source, which can ...
0
votes
0answers
6 views

Open MS EXCEL file from C# and end C# program

I have a program on C# and i want to put the results to .xlxs file. But the problem is, that i want to open to a user this .xlxs file, that the user can see it opened on his screen, and, at the same ...
0
votes
0answers
4 views

Is there a software that can filter files in sharepoint/teams?

I have a issue, where i have about 5k files. Its xsl, doc and pdf. I want to clean up my files, by using a filter software? anything that can filter it so that i can search/delete all files that are ...
0
votes
0answers
5 views

Automated and faster and reproducible making bar-plots with chart titles and error bars

I want to make 100 barplots with chart titles and error bars with some software that is faster than Excel with requires so much click and drag, and is better than R with creates graphs that are ...
0
votes
0answers
9 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 ...
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 ...