Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [microsoft-excel]

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

Filter by
Sorted by
Tagged with
17
votes
2answers
130 views

Creating a graph of connections between Office files

I'm preparing to move huge amount of files between file servers. The files are located in different shares within one of many servers. I thought it would be good to have clear vision of what is linked ...
10
votes
2answers
16k 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 ...
8
votes
4answers
256 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 Excel in a tabluar format but it often comes out strangely when I copy paste. I want to be able to get tables out of PDF ...
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 ...
6
votes
1answer
748 views

Program to convert Excel 2013 spreadsheets to LaTeX tables

I'm looking for a program or web-service that can convert Microsoft Excel 2013 spreadsheets to LATEX tables And if possible: free works on Windows 7 The package Excel-to-LaTeX only works for Ex­...
6
votes
2answers
144 views

How can contacts be shared within a small company (desktop/mobile) and also be usable in office apps

!Hi everyone I would like to ask you guys for advice. Currently I am helping a small organization (4 PC's) to improve their IT system a bit. The main problem is, that each of them is having their ...
5
votes
3answers
861 views

Compare excel sheets from two excel files

Is there a freeware that is portable (do not require to be install) and can compare two excel sheets that come from two different excel file. It will highlight the different by showing which cells is ...
5
votes
2answers
283 views

Software to merge 1500 xls spreadsheet files into one

Can anyone out there help me figure out how to best merge 1500 matching spreadsheets for analysis? They have the same columns, in the same folder. I have access to Access, Excel, SharePoint, Word, ...
5
votes
2answers
848 views

Scan a receipt and recognize text/numeric data on it

I'm looking for a software that can scan a receipt to retrieve data of total price, product's name and price, receipt date and receipt number. Some important criteria: The software can be created as ...
5
votes
2answers
75 views

Software (preferable Excel add-in or similar) to abbreviate large number of sentences based on user-set database

We have to take a large number of rows, each containing a text sentence. We need to abbreviate each sentence to have a character length of < 40, as we need to copy-paste the data to SAP which has ...
5
votes
1answer
316 views

Software library to create large excel files serverside

Story We have successfully been using Aspose cells for years, but we are looking ahead and noticing that as our reports grow in size, we are hitting limits as to what Aspose can handle. I'm looking ...
5
votes
1answer
929 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 ...
4
votes
2answers
6k views

Program to auto-update data in Excel files

Each day for work, I have to open 40-50 Excel files (the newer .xlsx format) and run the Data Refresh on all connections in order for them to pull in the latest numbers. As you can imagine, this takes ...
4
votes
1answer
1k views

PHP library to transform Excel .xls .xlsx to OpenDocument .ods

I want to automatically convert Excel files (.xls, .xlsx) to OpenDocument spreadsheets (.ods) Is there a PHP library for that? Or at least a command-line utility that I could call from PHP?
4
votes
1answer
279 views

Mac capable Access similar database software

How do I create a database application that satisfies these requirements? It must be capable of running on windows and mac operating systems. It must be similar visually to excel. The user needs to ...
4
votes
1answer
3k views

Picture Viewer to easily copy & paste into MS Office Excel

I need some open/free software for opening pictures with functionality to copy and paste it into another application (Excel in this case). Currently I have to: (1) Right click the file > (2) Edit > (...
3
votes
2answers
2k views

Program to import a Microsoft Excel spreadsheet into a MySQL table

I am looking for a program that can: import a Microsoft Excel spreadsheet into a MySQL table support cells containing line breaks support cells containing ' (and if possible any other character) If ...
3
votes
3answers
107 views

Graphical Reporting tool alternative to Excel

I am an academician and have all students' exam data in Excel (not only marks but also details of each question's response). At present I am using Excel to produce histograms and calculate some ...
3
votes
4answers
83 views

Where to start building simple database to streamline analysis for community organization?

I work for a research organization in India and have recently taken up with a program extending immunizations among poor rural communities. They're a fairly large organization but don't really have ...
3
votes
3answers
154 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 ...
3
votes
1answer
529 views

What is a good alternative to Zoho Reports?

What other services are similar to Zoho Reports? I performed a search for alternatives and all articles seemed to focus on the CRM and so it was a false comparison. Al the alternatives were about CRM ...
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
3answers
119 views

Software to learn Excel VBA without buying Excel

I have a job interview coming up, and I've been told to brush up on using Visual Basic Applications in Excel. That would be fine, but I have no experience with the BASIC language. On top of this, my ...
2
votes
6answers
8k 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 ...
2
votes
2answers
76 views

Program or library to read an Excel-based schedule hourly and read content out loud

I have an Excel-based hourly schedule that I change and check throughout the day. Is there some tool that would check every hour in the particular day and hour (see column and row) and if there is ...
2
votes
1answer
37 views

What is the best spreadsheet-like tool to manage structured data with tags and multiple columns of different sizes

I'm trying to find a tool which can fit my needs in the management of a list a scientific papers I read during my phd thesis. For each paper I collect title, authors, write a summary, give tags... I ...
2
votes
1answer
726 views

Using Microsoft Excel as user interface for a windows form application [closed]

I want to create a windows form application using c#, that uses Microsoft excel as interactive user interface, in the other word, I want to load the data from database to Excel, and after user ...
2
votes
5answers
89 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.). ...
2
votes
1answer
146 views

Excel alternative that uses JavaScript

I'm looking for a very simple Excel alternative that is cross platform, open source and uses JavaScript instead of the terrible Excel language (whatever it is called). So that every cell can have a ...
2
votes
1answer
21 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 ...
2
votes
1answer
46 views

Identify and concatenate data embedded in Excel Spreadsheets

We're looking at open data published in multiple excel spreadsheets with no standard format. The data can be embedded in multiple tables within a given sheet, e.g. | | | | ...
2
votes
1answer
47 views

Which software do I need for taking the values from video

which software can I use for taking the numbers from a video. For example I have an video with numbers 0, 250, 320, 0 , 0 ..... nothing else just numbers in the video. So I need these values to be put ...
2
votes
1answer
57 views

Data analysis software connecting to excel

I'm wondering which software would best be suitable for: plotting data, possibly interactive graphics statistics reading and writing excel files (numbers, currencies, enums, dates, possibly text) ...
2
votes
2answers
175 views

Web application to convert Excel files to PDF (Separate PDF for each worksheet)

Is there any web application to convert an Excel file with multiple sheets to PDF files? Each sheet will be created as a new PDF file. If I have 3 worksheets in Excel, I'll have 3 PDFs after ...
2
votes
1answer
23 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 ...
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 ...
2
votes
1answer
721 views

A virtual printer that will print onto a design and then save to computer on Windows

I'm after a piece of software that will show up as a virtual printer (for example how XPS printer shows in Windows in the print dialog) when selected and printed from, it overlays the print content ...
1
vote
4answers
395 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 ...
1
vote
2answers
34 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
2answers
36 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
35 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
2answers
116 views

Tool to recover Excel 2007 file password

I am looking for free software to recover my Excel file password. The file was created in MS Excel 2007.
1
vote
4answers
80 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
22 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 ...