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

On editing protected view using “ProtectedViewWindow.Edit”, settings under “Display options for workbook” are getting changed [closed]

When I call ProtectedViewWindow.Edit in ProtectedViewWindowOpen event, document gets open successfully without protected view but all settings under options-> Advanced -> "Display options for workbook"...
0
votes
1answer
8 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 ...
0
votes
1answer
21 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
8 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
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
17 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
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 ...
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 ...
0
votes
0answers
85 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
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,...
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
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 ...
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
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
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
12 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
14 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 ...
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 ...
1
vote
1answer
14 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
9 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 ...
2
votes
1answer
21 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 (...
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
11 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
8 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
4 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
8 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
10 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
17 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
13 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
18 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
14 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 ...