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
17k 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
277 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
3answers
272 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
2answers
850 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 ...
6
votes
1answer
805 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
145 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
930 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
285 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
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
329 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
945 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
280 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 > (...
4
votes
0answers
51 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
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
192 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
3answers
112 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
84 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
1answer
532 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
24 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
196 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
556 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
32 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
130 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
10k 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
77 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
41 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
874 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
92 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
194 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
28 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 (...
2
votes
1answer
24 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
47 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
60 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
179 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
32 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
1answer
26 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
117 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
121 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
269 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
808 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
3answers
298 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
4answers
397 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
36 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
37 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 ...