Questions tagged [microsoft-excel]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
39 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
39 views

QR scanner for making trade fair shopping lists

Is anyone aware of an android/iPhone app that would allow customers to go scan a barcode/QR code on an item and create an order list, that could be exported for our manufacturing orders? Bullet ...
1
vote
4answers
81 views

Tool/macro to make backups of Excel files

I made incorrect changes to an Excel file and saved it, and MS Excel (2003) makes no backup files like MS Word does (only autorecovery files, but that is of no use after clicking 'save'). Is there a ...
1
vote
1answer
223 views

Sharing an Excel sheet online and edited by more than one user [closed]

I want to share an excel sheet ( Editing Entries, New Entries ) over through online. More than two users will have the rights to do this. I heard of Google docs, but just looking for better option.
1
vote
1answer
113 views

Tool to convert SEC EDGAR Form 13F into Excel?

I'm using Windows 10. I'm looking for a tool to convert https://www.sec.gov/Archives/edgar/data/1037389/000103738919000272/xslForm13F_X01/renaissance13Fq32019_holding.xml to .xls. I found Intrinio on ...
1
vote
1answer
48 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
1answer
32 views

Huge excel file with python

I've a huge file in the size of around 600 MB, I've to write some python codes and generate new columns, for now, I'm using python, but unfortunately, no luck as I'm getting memory error to get ...
1
vote
1answer
38 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
vote
1answer
136 views

Alternative Windows program for editing Excel xml format spreadsheets

I don't have Microsoft Office at home, but would occasionally like to edit spreadsheets from work. We use the Excel .xml format also knows as "SpreadsheetML". Does anybody know of a program that will ...
1
vote
1answer
43 views

Interactive chart visualization with website integration

I'm looking for a tool or some kind of framework which lets me visualize Excel data interactively on a website. (independent of the user device if possible) I should be able to see the values when ...
1
vote
4answers
181 views

PDF or HTML form into Database (or Excel) then Merge into Pre-formatted Word Doc

I have been searching for an answer to this problem for literally years. I am not a full programmer, but have had previous experience. I have tried to hire people to do this with little success. I ...
1
vote
1answer
176 views

Software to handle large Excel .xls files

Some users receive XLS files from other offices for analysis, but these files are extremely large and the performance of Excel is low. I know the best solution could be transfer this information to a ...
1
vote
1answer
71 views

Excel's plugin for Budget?

Information: In a company, there are 6 people who use Excel to create budget. Unfortunately, there are lots of different copy of that file. Problem statement: I'am looking for a plug-in for excel ...
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
3answers
40 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/...
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
213 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
53 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
14 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
2answers
2k views

Web App front end for Excel (or similar spreadsheet muscle)

I would like to create a web application that steps a user through the building of an economic model, ultimately exportable as a complex multi-worksheet excel with calculations throughout. It would be ...
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
1answer
87 views

System that allows me to create a form that users can fill to assemble Word/Excel files

I am being tasked with creating a form (I work as an Engineer), a bit like an Excel spreadsheet where the output will be a list of "Part numbers". I would like to be able to create a form, that has ...
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
392 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
1answer
20 views

Software to analyze task duration and progress [closed]

I have a spreadsheet that has information of 50+ tasks that take place, their start and stop time. They all have a very different begin time, end time and duration. I have to go through each task ...
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
2answers
40 views

how to work on word and excel from different machines?

I use MS Word and Excel a lot. However, when i'm at work I send copy of my work to email and when i'm at home I download the copy from the email and so forth. I need a way to make my copies update ...
0
votes
1answer
318 views

Portable convert excel to mysql

Is there a portable windows (xp and above) software that can convert a excel file (xlsx, xls and ods) into mysql file (sql)?
0
votes
3answers
116 views

Analyse data contained in Excel file

I have been using computers for about 16 years, never used excel or similar software, maybe once. So my excel knowledge is 0. Maybe what I'm about to ask is easy maybe not. The first part of the ...
0
votes
1answer
19 views

C++ library to read Excel Spreadsheets

I've got a language phrase translation table in Excel. I would like to write, in C++, a program that creates C++ source data tables from the Excel Spreadsheet. Is there are recommended library for ...
0
votes
1answer
28 views

Interactive spreadsheet survey

I'm looking for an online survey platform which would allow participants to input information into a blank interactive online spreadsheet. The spreadsheet would be blank for each individual ...