Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-excel]

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

1
vote
2answers
30 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
0answers
11 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 ...
0
votes
1answer
26 views

Is there a text editor which displays column numbers and/or displays text in a grid to quickly glance column numbers?

I basically need a text editor which displays text in a grid, so that I can know the exact column numbers of the text. The numerical simulation software I am using, TOUGH+ (written in FORTRAN), has a ...
0
votes
2answers
29 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
12 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 ...
0
votes
0answers
5 views

iPhone app to open a spreadsheet, click on the client's number and dial it directly from the data sheet

I use MS Excel at work for various client contact databases. I use Dropbox/Google Drive so that I can access the data from anywhere using my iPhone. I would like to be able to use my iPhone X to open ...
2
votes
1answer
21 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 ...
3
votes
0answers
20 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. ...
1
vote
1answer
12 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
11 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 ...
0
votes
0answers
34 views

Which JavaScript Library use to generate complex psychrometric chart to replace excel

I am trying to get some recommendation, advice how to replace my current process where I use local macro excel with JS to reproduce Psychrometric Chart. I have macros in excel with calculation that I ...
0
votes
0answers
23 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
1answer
30 views

Select cells in Excel, convert to Markdown, copy to clipboard

Is there a software (an Excel plugin, Macro, ...) or any workaround to select table cells in an Excel Sheet, and to convert the selected cells to Markdown-Table Code, perhaps by copying it to the ...
0
votes
0answers
15 views

Tool that guides converting / mapping JSON, XML, Excel based data to various SQL Table Formats

I would hope this tool would let me select columns for import from excel and then rigidly apply data type rules, allow custom conversion functions, and provide some sort of "workflow" that retains the ...
0
votes
0answers
29 views

parent-child tree with csv data?

I found this solution posted by Vincent Tang -How do you create a parent-child tree with table/excel data?. However, I have 50K rows in the input file and the program hangs. Any better way to get ...
0
votes
1answer
29 views

Is there any plug-in or method that saves passwords for excel and/or word?

As I stated in the question, I need such plug-in since I'm dealing with password protected excel and word files and these passwords are mostly same but long and complicated. Such plug-in will save ...
0
votes
1answer
27 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 ...
2
votes
0answers
27 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 ...
1
vote
0answers
79 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 ...
2
votes
1answer
32 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 ...
-1
votes
1answer
53 views

Converting Excel into a website?

I need to build a tool which will take a list of items (comma separated), look these items up in a separate sheet/database and show the information about each of the items listed. I can make this in ...
1
vote
1answer
34 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 ...
0
votes
0answers
14 views

Calendar + Tag Sortable Scheduling Software

I'm looking for a scheduling application with specific features. Here's the situation: My job requires me to call students once every two weeks. I schedule with the students when we are in class ...
1
vote
2answers
803 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 ...
2
votes
4answers
79 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
2answers
37 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
29 views

How to convert stanza based data to row based?

I have data files that are in stanzas: Item 1: Attribute 1 Item 2 Attibute 2 Item 3: Attr 3 Item 4: Attr 4 E.g. The following is a typical stanza. This is difficult to work with. I want to ...
2
votes
1answer
527 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 ...
1
vote
0answers
37 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
82 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 ...
2
votes
3answers
97 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 ...
0
votes
0answers
14 views

Adding interconnected numbers to a drawing

For a SMED (single minute exchange of die) project I am working on I have to record the movements of persons on the shop floor to see if they are moving ineffeciently. I would like to do this by using ...
4
votes
1answer
275 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 ...
2
votes
3answers
109 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
1answer
44 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. | | | | ...
1
vote
0answers
25 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 ...
3
votes
0answers
134 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 ...
2
votes
5answers
6k 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
22 views

I need a software that lets me create an excel spreadsheet with mp3 file names and their descriptions

What I mean by that, is something which plays me a sound file, lets me describe it, plays the next one, you get the point. And until the folder ends. When all of this is done, it generates a excel ...
1
vote
2answers
110 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
1answer
73 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 ...
2
votes
5answers
88 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
98 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 ...
0
votes
2answers
8k 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 ...
0
votes
1answer
24 views

Is there a VBA function or plugin for Excel that will let me use arbitrary date formats to parse dates from string?

For instance, given a string like 18:40:59.795Z I'd like to be able to call TOTIME(A1, "HH:MM:SS.mmmZ") or something like that. Time conversion in Excel is a pain; every time I need to do it I have to ...
0
votes
1answer
21 views

Opening and sorting huge files

I am working with huge files like 2.000.000.000 rows. I need this file to be sorted, maybe filtered an so on. Can you recommend me a software? Preferably on Linux, but can be in any OS. I am looking ...
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 ...
0
votes
1answer
22 views

Limiting editing options in PDFs or Excel

I created an application form in Excel and I want to send it to my group members now. Here the problem is they can edit it. But I don't want to allow them to edit the questions in the form while space ...
1
vote
1answer
163 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 ...
8
votes
4answers
236 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 ...