Questions tagged [microsoft-excel]

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

Filter by
Sorted by
Tagged with
2
votes
3answers
41 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/...
0
votes
1answer
20 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 ...
2
votes
5answers
116 views

Looking for Online Data Storage Software/Web Application

The company that I work for has collected a LOT of data (hundreds of thousands of entries) in Excel spreadsheets that are separated into labelled columns (ex. Name, Number, E-mail, Address, etc.). ...
0
votes
1answer
10 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
29 views

What are good alternative to spreadsheets for making complex corp price list-calculators

I work in a company which exclusively uses Excel for making price list calculators for selling managers. These price lists are very huge and complicated because of complexity of production, where you ...
0
votes
1answer
31 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) ...
2
votes
1answer
56 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 ...
8
votes
3answers
290 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 ...
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
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 ...
0
votes
1answer
114 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
30 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 ...
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 ...
0
votes
1answer
39 views

Fetch data from web service in Excel which language/tool to use

I have a requirement to make a functionality in Excel to fetch and update data to/from a web service and I need to choose a language / tool to develop this. The features I am looking for. Multi ...
1
vote
1answer
215 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 ...
2
votes
4answers
132 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 ...
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 ...
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), ...
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 ...
4
votes
7answers
16k views

How to convert an Excel spreadsheet into an interactable web page?

I have a Microsoft Excel spreadsheet which I want to lease out to people. I would ideally like to be able to convert it to an interactable web page. The spreadsheet contains many special functions ...
0
votes
0answers
19 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 ...
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 ...
0
votes
0answers
179 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
2answers
48 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 ...
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 ...
1
vote
4answers
399 views

OLAP Server for Excel users

My company currently uses CSV files along with Excel (Pivot Tables) as a reporting instrument. We export CSV from our invoicing system (which is based on MSSQL, so we have MSSQL Server running, just a ...
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 ...
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 ...
9
votes
4answers
315 views

Software that can extract tables from PDF files

I often receive table data in PDF files. I want to be able to get that into MS Excel in a tabular format but it often comes out strangely when I copy-paste. I want to be able to get tables out of PDF ...
5
votes
1answer
987 views

Fast generation of Excel reports using C#

We would like to use Open XML in my project to generate Excel reports (.xlsx). We have requirement where we do styling, copying, inserting ranges with format, inserting page breaks. It is important ...
10
votes
3answers
20k views

Microsoft office viewer on Linux

I am working in a big non-private hospital where we want to convert to open-source starting with office/productivity software and then installing Linux. Microsoft is all over and even if we could ...
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 ...
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)?
2
votes
4answers
368 views

Looking for 64 bit Windows 7 spreadsheet program

I have used MS Excel 2007 for many years on a 32 bit computer. My newer computer is a 64 bit Windows 7 (yes, it's an antique :-). The 2007 software will not install on my 64 bit computer. I spoke ...
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
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, ...
3
votes
3answers
204 views

Tool for converting Excel files to CSV

We require a tool/program/utility that can do the following - Scan folders to look for Excel files at regular intervals. The Excel file might have different formats and the output has to be in a ...
0
votes
2answers
15 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
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 ...
2
votes
1answer
44 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
votes
1answer
13 views

Uploading csv files to an R file without having excel

I'm starting an internship where I'll be uploading different csv files into some R files I'm working on. Problem is, I don't have excel and can't really pay for Microsoft Office. Are there any options,...
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/...
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
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
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 ...