Questions tagged [microsoft-excel]

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

60 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
77 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
25 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
222 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
662 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
33 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
0answers
29 views

Alternative to MS Excel for non-calculating (text & images) tables

In my company and in probably thousands of other companies, Excel is misused for word processing (creation of tables containing mainly text, for example project plans and lists of all sorts), ...
2
votes
3answers
43 views

Program to take spreadsheet data, compute data, charts/graphs for multiple pages that allows user input

I have a spreadsheet that is for a group of clients. Each line of data has information on insurance claims, of which include a client number that is unique to that client. I am looking for a program/...
2
votes
1answer
57 views

Mobile Friendly Data Entry App

I am trying to create a data entry "app" to collect daily readings across our site. Here are the three biggest constraints: Software - ideally, we would use some software within the Microsoft 365 ...
2
votes
0answers
123 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
281 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
8 views

Browser app for editing excel files by formular

I have an large excel file with a lot of different tabs in microsoft excel (laying in OneDrive). I want to create some formulars (viewing and writing data in a dialog in a structured way) to make ...
1
vote
0answers
12 views

Push and pull online software solution

Current Situation In our office environment before we moved over to Office 365, we designed Excel workbooks to cover our admin tasks, these workbooks were unique to each member of staff. All staff ...
1
vote
0answers
21 views

Software for categorizing data based on language and type

Currently, I'm using windows file explorer for categorizing. There are folders for years (2017, 2018, etc.) and each of them has sub-folders for types (type_1, type_2, etc.) and under each sub-folder, ...
1
vote
0answers
9 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
12 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
12 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
19 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
1answer
216 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 ...
1
vote
0answers
9 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
0answers
6 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
16 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
54 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
15 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
14 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
15 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
18 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
145 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
49 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
28 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
393 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
218 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
346 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
237 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
242 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
187 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
76 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
1answer
12 views

Web-app to view Microsoft Excel XLSX spreadsheets without downloading anything

Please recommend a web-app to view Microsoft Excel XLSX spreadsheets without downloading anything. Looking for something that will run in a web browser (preferably Firefox) on a device that does not ...
0
votes
1answer
34 views

Software/Python library for Ontology building from Excel

I'm tasked with reading certain parts of an extensive excel of building equipment and mapping it into an ontology. The specific part that needs to be mapped are a variety of Air Handling Units (AHU) ...
0
votes
0answers
11 views

A tool or addon to export excel as CSV including image cell

I'm looking a tool or addons for any of Online Excel Live, Google SpreadSheet, OpenOffice and LibreOffice to convert my excel which includes image as a cell into CSV format which will contain image as ...
0
votes
0answers
15 views

python module to insert images to existing excel chartsheets

I need to add images to existing excel chartsheets in python. Constraints: on a Linux machine maintaining compatibility to Excel 2016+ My go-to for editing existing excel documents so far is ...
0
votes
0answers
20 views

Selenium basic vba

My organization is losing MS internet Explorer. This will make my Excel VBA web-automation scripts obsolete. I've heard that Selenium Basic will allow Excel VBA to control Edge and Chrome Browsers ...
0
votes
0answers
26 views

What technology should I use to programatically create an Excel file?

I have a HTML form that allows a user to enter a start and end date. When the user submits the form, an AJAX call is made to server side code written in Java. It returns JSON data relevant to the date ...
0
votes
0answers
190 views

Dashboard (widget, gadget) of excel on desktop of Windows 10

I'm looking for a way to show and modify on my desktop a spreadsheet of an excel file. Online I found only some paid software (Spinetix Elementi) which does it. Can you tell me if there are free ...
0
votes
0answers
12 views

Excel-like software with different sized columns in each row

I thought having different sized columns would make taking notes more convenient, but I need to have different sized columns for that. Is there any software that can do this job?
0
votes
0answers
17 views

Is there any tools or software to combine used for collecting and archiving data?

I'm looking for some tools/ software for below procedure at my company (a total of 50 staffs): Send a notification about the total hours one staff worked a month to him/her. But I would like to have ...
0
votes
1answer
116 views

Good, free software for candlestick charting (using CSV or text input file)

I am looking for Desktop software which takes Daily Open/Close/High/Low (and possibly Volume) input as csv or any text format. I already have Excel but I found several shortcomings with Excel If ...
0
votes
1answer
26 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
2k 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/...