Stack Exchange Network

Stack Exchange network consists of 174 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
1answer
10 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
16 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
22 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
18 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
14 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
18 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
27 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
23 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
22 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
62 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
31 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
50 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 ...
0
votes
1answer
22 views

QR scanner for making trade fare 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
13 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
632 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 ...
0
votes
3answers
67 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
35 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
26 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
415 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
33 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
80 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
96 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
13 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 ...
3
votes
1answer
272 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
103 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
43 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
24 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
113 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
4answers
5k 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
21 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
105 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
68 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
87 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
79 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
6k 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
23 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
20 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
46 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
21 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
0answers
128 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
229 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 ...
3
votes
2answers
430 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 ...
1
vote
1answer
40 views

Interactive chart visualization with website integration

I'm looking for a tool or some kind of framework which lets me visualize Excel data interactively on a website. (independent of the user device if possible) I should be able to see the values when ...
0
votes
0answers
70 views

Convert PDF with tables to Excel, Mac OSX

Wanting to convert tables provided in PDF into Excel spreadsheets, preferably free. The tables are the same format on every page, with headings at the top of every table. The headings section can be ...
0
votes
1answer
196 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)?
5
votes
1answer
305 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 ...
0
votes
4answers
133 views

PDF or HTML form into Database (or Excel) then Merge into Pre-formatted Word Doc

I have been searching for an answer to this problem for literally years. I am not a full programmer, but have had previous experience. I have tried to hire people to do this with little success. I ...
1
vote
1answer
18 views

Software to analyze task duration and progress [closed]

I have a spreadsheet that has information of 50+ tasks that take place, their start and stop time. They all have a very different begin time, end time and duration. I have to go through each task ...
1
vote
0answers
170 views

Tools to reverse-engineer an Excel spreadsheet

I have at various times been asked to improve some predictive model whose only implementation and documentation is an Excel spreadsheet. What I want instead is a concise set of equations describing ...