Questions tagged [microsoft-excel]

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

Filter by
Sorted by
Tagged with
-1
votes
2answers
26 views

Convert CSV file to another layout

I would like to change the layout of a input CSV file and change the layout of values. So the initial Format has headings like: - Customer Zone Type 1 2 3 4 5 6 7 8 9 10 11 12 Under the number ...
0
votes
0answers
34 views

Line Graphing from dynamic excel data

I have been developing a tool that processes timetable data and would like some advice on how to develop the graphical output. I do intend to keep the data in excel, but would like to output to a ...
1
vote
0answers
9 views

What program would you use to do simple querying on tabular data?

I often receive data in Excel files and want to some simple lookups the way I would with SQL. In Excel, doing something like select b.field from a join b on a.a1 = b.a1 and a.a2 = b.a2; is doable with ...
0
votes
0answers
10 views

What software should I use to build an app that can communicate with SharePoint?

I'm trying to build an app where the user can draw with their finger and have the drawing be placed in an Excel file which is sent to SharePoint. It can either be an android or web application. I ...
0
votes
1answer
19 views

Compare two excel sheets

csv spreadsheets with the following data: Sheet 1: ID Name Address City PostalCode Phone Sheet 2: ID Name Address City PostalCode Phone I would like to compare the two sheets for added rows, ...
1
vote
1answer
38 views

Converter for Microsoft Office XML to OOXML (Office Open XML)?

We have some software producing a spreadsheet in the Microsoft Office XML file format (introduced in Office XP) and would like to convert this to the newer OOXML format that has been used with Office ...
3
votes
3answers
118 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

Software for barcode registry

I have a fruit harvesting business that I would like to find existing, or implement software to keep a registry of scanned bin barcodes for each day, per team, and block area of an orchard. Any given ...
1
vote
0answers
6 views

Software for 3D Processing

I have a project for my work which requires me to take XYZ data from a CSV/Excel file using this data I need to generate a 3D line/spline then using this I need to render small segments of a pipe ...
1
vote
0answers
16 views

Connect Excel to HDFS and update data real time

I am trying to figure out a method or software for updating data into HDFS real time. My requirement is as follows: I will have an Excel in a server. That Excel data needs to be loaded into HDFS. IF ...
1
vote
0answers
53 views

Software to connect Apache Derby DB with Excel

I would like to use a Apache Derby database as source for an Excel file so that I can use the tables and manipulate them in Excel. I have tried to connect the Derby DB with the Derby ODBC Driver ...
0
votes
1answer
76 views

Where can I find some fun Excel sample data to download?

Are there any web applications out there that offer free Excel sample data utilizing fun topics like perhaps Star Wars characters?
1
vote
0answers
14 views

Software to annotate PDF from Excel or Python

I have a large PDF files. Each PDF page contains a chart and also includes a unique identifier, i.e. chart number. I have individual comments for each chart and would like to insert these in the ...
1
vote
0answers
14 views

Automate the process of running an excel macro on Sharepoint

Is there any way to automate the process of running an excel macro from an excel file in SharePoint without having to do it manually every day? From my understanding, Sharepoint does not have this ...
1
vote
2answers
39 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
2answers
39 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
15 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 ...
1
vote
1answer
646 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 ...
1
vote
1answer
39 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 ...
2
votes
1answer
28 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
33 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
25 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
136 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 ...
0
votes
1answer
35 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
85 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 ...
1
vote
1answer
87 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 ...
0
votes
0answers
23 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 ...
5
votes
3answers
1k 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 ...
2
votes
1answer
50 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 ...
4
votes
0answers
77 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
145 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 ...
-1
votes
1answer
59 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 ...
2
votes
1answer
49 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. | | | | ...
0
votes
1answer
47 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
259 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
0answers
28 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
4answers
181 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
2answers
2k 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
2answers
40 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 ...
2
votes
1answer
1k 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
49 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 ...
0
votes
2answers
23k 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
0answers
16 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
282 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
168 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 ...
5
votes
1answer
368 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 ...
1
vote
0answers
28 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 ...
0
votes
0answers
29 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 ...
2
votes
1answer
50 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
26 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 ...