Questions tagged [microsoft-excel]

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

-1
votes
0answers
3 views

Automation software or approach for handling accounting and financial statements analysis

I'm not interested in invoicing/reporting automation software. What I'm currently trying to do is applying machine learning tools to automate a lot of manual financial analysis works at my company. We ...
-2
votes
0answers
7 views

ROUNDUP and ROUNDOWN are not working same in ms excel [on hold]

In Microsoft Excel ROUNDUP(235.644,2) gives an output as 235.65 that means it round the value to closest upper number but ROUNDDOWN(12.6999,2) gives an output as 12.69 instead of 12.65 or 12.60. ...
0
votes
1answer
11 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
6 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 ...
-1
votes
0answers
5 views

How to connect to a remote file using CData Excel JDBC driver?

Using CDATA to connect to local excel file with jdbc url below: Connection conn = DriverManager.getConnection("jdbc:excel:Excel File=C:\MyExcelWorkbooks\SampleWorkbook.xlsx;"); Can we connect to a ...
0
votes
0answers
10 views

RStudio or SQL for data cleaning

I am wanting to detect corrupt and inaccurate records to check for data quality from large data sets that originate from Microsoft Access and Excel. Things I would like to check for: Validity which ...
0
votes
0answers
7 views

How do I solve a Large (1141 variable, 63 constraints) non linear optimization problem in excel? [closed]

I structured an optimization problem in excel with the aforementioned number of variables and constraints. All the decision variables are binary. Essentially the model is supposed to spit out a 7 day ...
0
votes
0answers
7 views

Free, multi-user searchable list with categories

I have been asked to create a "searchable" list of referral sources that could be: Updated and accessed by multiple people Easily searched The team I'm with hates Access. None are very tech savvy. ...
0
votes
0answers
9 views

How to calculate the maximum value of 3 items or more in Tableau [closed]

I use Tableau to analyze data. Like Excel, I want to calculate the maximum value among multiple items (more than 3 items) using MAX function. However, Tableau's MAX function could only specify up to ...
0
votes
0answers
5 views

Getting data in .xlsx format, trim it online, and send it by email

I am looking for some software that is able to get a file in xlsx format, so we can trim that data (automatically, possibly online, twice a month) and resend it to an email address. Is there ...
0
votes
0answers
3 views

Easy to use WIndows tool to view HDF5 files and/or convert to CSV

I tried using HDFView (https://www.hdfgroup.org/downloads/hdfview/ ), but it doesn't display the columns clearly. It groups all data columns into an array and removes the column headings when I try ...
0
votes
0answers
5 views

Pre-Translation Microsoft Excel using online APIs from a language to another

I'm looking for any solution to pre-translate values from one language to another one in my Excel Worksheets using any free translation API (Google, Yandex, Microsoft...) The goal is to minimize user ...
0
votes
0answers
6 views

Microsoft Word and Excel

I'm looking for a light and simple alternative to Microsoft Word. I would like an application that can run on IOS10 and also mobile applicability on the go for editing.
0
votes
0answers
7 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 ...
0
votes
0answers
13 views

Android app for quick data notes

I am looking for an Android app in which I can quickly input numbers on standard sheets, without always switching on the touch keyboard. I'll explain a little further. I periodically go to some shops ...
1
vote
0answers
5 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
12 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
votes
0answers
35 views

What is best software to convert Excel XLSX to vCard?

As a Windows user, I manage and store all my contacts in a Excel XLSX file. Now, I want to export all Excel XLSX contacts into a single VCF so that I can import the VCF in my other devices. I tried to ...
1
vote
0answers
9 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
0answers
11 views

COTS EDI software to view an XSD in Excel

Which commercial off-the-shelf software offers a feature to make an EDI data mapping specification for remote programmers based upon an XSD file? The remote programmer will not have access to the COTS ...
1
vote
0answers
5 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
10 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 ...
0
votes
1answer
13 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
2answers
33 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
13 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
30 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
2answers
34 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
15 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
23 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
14 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
54 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
1answer
32 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
36 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
19 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
42 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
28 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 ...
3
votes
0answers
32 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
107 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
36 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
56 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
917 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
93 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 ...