Questions tagged [microsoft-excel]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
6 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
6 views

Export service schedule to Excel in GCSS-A [on hold]

I’m in the Equipment Situation Report (DISP_EQU_SIT) in GCSS-A, I pull up the service schedule, everything is there. There’s a button that says “spreadsheet” that leads to a series of questions and ...
0
votes
0answers
2 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
1answer
16 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 ...
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
260 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
4 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 ...
1
vote
1answer
14 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 ...
2
votes
6answers
8k 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
2answers
11 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 ...
-1
votes
0answers
3 views

Jar required for downloading Excel file from java application

Does poi jar is enough to download .xlsx (Excel 2016) format using XSSF in java application or poi jar is valid upto Excel 2013
0
votes
1answer
15 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
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 ...
1
vote
1answer
19 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 (...
8
votes
1answer
249 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
votes
1answer
12 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
14 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/...
3
votes
2answers
511 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
30 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 ...
1
vote
0answers
22 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
9 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
7 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
8 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
7 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
1answer
10 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 ...
0
votes
0answers
6 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
8 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
22 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
10 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 ...
2
votes
4answers
104 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
0answers
9 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
19 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
26 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
1answer
242 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
7 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
8 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
5 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
7 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
15 views

Running an Excel Macro on a Windows Server

I have an Excel Macro running on my local machine everyday at 6:00 AM using Task Scheduler that does the following: Macro opens a couple of other Excel Files that are connecting to a SAP Cube via ...
0
votes
0answers
9 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
0answers
3 views

Library to create and write line charts to Excel workbook in Python

I need to make about 30 line charts, preferably somehow within a for loop. They would need to be created within a sheet within an Excel workbook and saved there. I've been using openpyxl for parsing ...
0
votes
0answers
7 views

Need software recommendation to fetch data from a URL

I am trying to fetch store name and cashback percentage from this website using google sheet's importxml function. Put following commands with no success. Please help =importxml("https://www....
0
votes
1answer
13 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
9 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 ...
0
votes
0answers
11 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

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
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 ...