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
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 ...
0
votes
2answers
13k views

How do you create a parent-child tree with table/excel data?

I'm using access to model a relational database. I have the following data in a 2 column format: The result should generate a tree/bullet point diagram that looks like this: A B C D G E F ...
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 ...
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 ...
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 ...
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 ...