Questions tagged [microsoft-excel]

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

Filter by
Sorted by
Tagged with
2
votes
4answers
312 views

Looking for 64 bit Windows 7 spreadsheet program

I have used MS Excel 2007 for many years on a 32 bit computer. My newer computer is a 64 bit Windows 7 (yes, it's an antique :-). The 2007 software will not install on my 64 bit computer. I spoke ...
1
vote
3answers
27 views

Program to take spreadsheet data, compute data, charts/graphs for multiple pages that allows user input

I have a spreadsheet that is for a group of clients. Each line of data has information on insurance claims, of which include a client number that is unique to that client. I am looking for a program/...
8
votes
3answers
272 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 ...
1
vote
1answer
15 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
22 views

Tool to convert SEC EDGAR Form 13F into Excel?

I'm using Windows 10. I'm looking for a tool to convert https://www.sec.gov/Archives/edgar/data/1037389/000103738919000272/xslForm13F_X01/renaissance13Fq32019_holding.xml to .xls. I found Intrinio on ...
0
votes
1answer
26 views

Good, free software for candlestick charting (using CSV or text input file)

I am looking for Desktop software which takes Daily Open/Close/High/Low (and possibly Volume) input as csv or any text format. I already have Excel but I found several shortcomings with Excel If ...
1
vote
0answers
19 views

Software for categorizing data based on language and type

Currently, I'm using windows file explorer for categorizing. There are folders for years (2017, 2018, etc.) and each of them has sub-folders for types (type_1, type_2, etc.) and under each sub-folder, ...
0
votes
1answer
18 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 ...
3
votes
2answers
556 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 ...
0
votes
1answer
35 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 ...
0
votes
0answers
10 views

Transfer content from google sheet to external excel file

I’m trying Google Form and its tool to generate a sheet document based on the answer of the form. Now, I’d like to transfer the content from this sheet to an external excel file, to keep it updated as ...
1
vote
1answer
32 views

How can I programmatically insert an image in to an excel file?

I have a folder with an excel file and an image. Which programming language can I use to insert the image to a cell programmatically? The files are located on a Linux server running a strictly ...
2
votes
4answers
117 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
1answer
20 views

How to import table data from excel into Azure FROM LINUX

I'm in a database management class and the professor strictly teaches toward windows machines, so she uses Microsoft SQL Management Studio to interface with our databases. I have a linux machine, so I ...
1
vote
1answer
322 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 ...
0
votes
0answers
17 views

Cloud-Based Alternative to Microsoft Excel? Main Requirement = Conditional Formatting

I currently use the desktop version of Microsoft Excel to visualise data tables using data bar gradient conditional formatting. For example like this: https://www.contextures.com/images/...
2
votes
1answer
32 views

Mobile Friendly Data Entry App

I am trying to create a data entry "app" to collect daily readings across our site. Here are the three biggest constraints: Software - ideally, we would use some software within the Microsoft 365 ...
0
votes
0answers
11 views

How to solve a non linear equation in nodejs / javascript

I have to solve an excel solver equation. Which content some non linear equations. let assume X is 12*1 vector of unknown values. the element values are x1,x2,x3,..,x12 y1,y2,...,y12 are known ...
0
votes
0answers
14 views

Excel template field mapping software

We have an excel file in a specific format that loads data into our internal system. Example of the file Name, Cost, Location, Notes We receive data from our clients in different formats (>100 ...
3
votes
3answers
192 views

Tool for converting Excel files to CSV

We require a tool/program/utility that can do the following - Scan folders to look for Excel files at regular intervals. The Excel file might have different formats and the output has to be in a ...
0
votes
2answers
14 views

VBA in Excel vs Access for data conversion

We are upgrading our enterprise software and part of that effort I have to perform sales order (data) conversion from legacy to new software. I have moderate experience with macros/VBA in excel and I ...
0
votes
1answer
23 views

Interactive spreadsheet survey

I'm looking for an online survey platform which would allow participants to input information into a blank interactive online spreadsheet. The spreadsheet would be blank for each individual ...
0
votes
0answers
12 views

How to handle a very large CSV file

The authors of a paper on migrating birds have made public a CSV file which has about 707,000 rows. These represent the flight path coordinates of 707 flights made by individual birds. I want to ...
0
votes
0answers
4 views

Intelligently identifying and analyzing tabular data in Excel spreadsheet

Our company is building an online system that needs to accept Excel files as part of the registration process of our service. Our system will only be interested to consume what looks like columns and ...
0
votes
0answers
6 views

Machine learning in data extraction

Are there any tools that have “self leaning and auto transformation” capability whereby we can interrogate a client-provided file in it’s native format, identify key data elements, and pull pertinent ...
0
votes
1answer
283 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)?
0
votes
0answers
5 views

Tools that can do AI based document-data-extraction

I have a requirement for an “auto transformation” capability whereby we can interrogate a client-provided file in it’s native format, identify key data elements, and pull pertinent content into a ...
2
votes
6answers
10k 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
15 views

Help developing a golf score tracking mobile application

I, along with three other people, are assigned a project for our upper-level college course. We are responsible for creating a mobile application for our schools golf team. Here are the specifications ...
2
votes
1answer
28 views

C# Library for manipulating Excel Files?

I'm working on a project to migrate excel data into new excel files that are compatible with another system. As part of this work, I have to do a lot of data manipulation between excel sheets (...
-1
votes
1answer
13 views

Uploading csv files to an R file without having excel

I'm starting an internship where I'll be uploading different csv files into some R files I'm working on. Problem is, I don't have excel and can't really pay for Microsoft Office. Are there any options,...
0
votes
0answers
616 views

Generalized Excel VBA tool to run SAP reports and save output

My team often needs to extract data from the SAP R3 GUI into a file format such as Excel. We have been using VBA scripting to do this, using the approach described in https://stackoverflow.com/...
1
vote
0answers
27 views

Best Tool for Analyzing Multi-Tab Excel Files with 100-500k Records

I have started a new job and I need to analyze client's databases. Many times when we first meet with them we just get a huge Excel file with a dozen or so tabs and a partial to full dump of various ...
0
votes
0answers
11 views

Software for backing-up my phone text messages into php/excel

Does any one know an android software or web application for converting phone text messages into sql/excel. Its only for representation purposes and i think i can use them in the future.
1
vote
0answers
8 views

Mapping Application for Excel

I'm not sure if this is the right place to ask this question but I need to map around 20 truck routes that are listed in excel. I would like to plot each stop as a point on a city map, and then draw a ...
0
votes
0answers
9 views

Suggestion for an open source to be used as UI and to consolidate data into Excel Spreadsheet

We have a table in MS Excel, where different users enter into different rows of data. All the data is collected and consolidated into the same sheet. Kindly suggest a web-based open-source, which can ...
1
vote
0answers
8 views

How to manipulate Excel with python

I would like to perform some operations on an existing excel files which already contains some datas and formulas. It contains also charts. The operations that I would like to do are adding some ...
0
votes
0answers
7 views

Open MS EXCEL file from C# and end C# program

I have a program on C# and i want to put the results to .xlxs file. But the problem is, that i want to open to a user this .xlxs file, that the user can see it opened on his screen, and, at the same ...
1
vote
0answers
11 views

Which programming language works with tables and databases, considering reports and GUI?

I’ve been working with VBA previously but i want to learn other programming language, having a project in place I would like to know which language to pick and start learning… This project is based in ...
0
votes
0answers
4 views

Is there a software that can filter files in sharepoint/teams?

I have a issue, where i have about 5k files. Its xsl, doc and pdf. I want to clean up my files, by using a filter software? anything that can filter it so that i can search/delete all files that are ...
1
vote
1answer
27 views

Huge excel file with python

I've a huge file in the size of around 600 MB, I've to write some python codes and generate new columns, for now, I'm using python, but unfortunately, no luck as I'm getting memory error to get ...
1
vote
0answers
14 views

Library to develop web-based spreadsheet, compatible with Excel and PDF

I'm looking for open source library's which can make own web editor for editing excel sheets like Google Spread sheet. I want webify the excel sheet & Pdf as web application. Are there any Open ...
0
votes
0answers
5 views

Automated and faster and reproducible making bar-plots with chart titles and error bars

I want to make 100 barplots with chart titles and error bars with some software that is faster than Excel with requires so much click and drag, and is better than R with creates graphs that are ...
0
votes
0answers
38 views

Tool to connect Excel VBA macro to IBM AS/400 Access Client

I am working with data in excel and IBM AS/400 Access Client. they linked together using vba macro. However, recently my company wants to change to IBM AS/400 Access Client Solution which is the ...
-1
votes
2answers
23 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
32 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 ...
0
votes
0answers
12 views

Cricket Scorecard in Excel

Is it possible to create a cricket score card in excel like the way in an app. like when user enter what happens in one ball, say the striker takes a single, when I enter one in a cell, it ...
0
votes
0answers
11 views

SSIS Excel (.xlsx) Connector to SQL Server 2012/2016 recommendations?

Any recommendations on 3rd party Excel Source/Destination Connectors for SSIS to SQL Server 2012/16? What are the kinks? I really can't find reviews on these things anywhere. We need something ...
0
votes
0answers
6 views

repeat cell references in formula in Excel

How can I repeat a range of cells referenced in a formula in excel? for example I want to have AVERAGE(A1,B1)/STDEV.S(A1,B1) I want the 2nd reference(A1,B1) linked with the 1st one so that when one is ...
1
vote
0answers
8 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 ...