Questions tagged [microsoft-excel]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
27 views

Is there a VBA function or plugin for Excel that will let me use arbitrary date formats to parse dates from string?

For instance, given a string like 18:40:59.795Z I'd like to be able to call TOTIME(A1, "HH:MM:SS.mmmZ") or something like that. Time conversion in Excel is a pain; every time I need to do it I have to ...
0
votes
1answer
30 views

Opening and sorting huge files

I am working with huge files like 2.000.000.000 rows. I need this file to be sorted, maybe filtered an so on. Can you recommend me a software? Preferably on Linux, but can be in any OS. I am looking ...
4
votes
2answers
6k views

Program to auto-update data in Excel files

Each day for work, I have to open 40-50 Excel files (the newer .xlsx format) and run the Data Refresh on all connections in order for them to pull in the latest numbers. As you can imagine, this takes ...
1
vote
0answers
187 views

C# library for Windows store apps, to display .ppt .xls

Im searching for a library that allows the viewing of powerpoint files(.ppt) and Excel files(.xls) is there anything of sorts in windows store apps?
1
vote
1answer
43 views

Interactive chart visualization with website integration

I'm looking for a tool or some kind of framework which lets me visualize Excel data interactively on a website. (independent of the user device if possible) I should be able to see the values when ...
1
vote
1answer
20 views

Software to analyze task duration and progress [closed]

I have a spreadsheet that has information of 50+ tasks that take place, their start and stop time. They all have a very different begin time, end time and duration. I have to go through each task ...
5
votes
2answers
290 views

Software to merge 1500 xls spreadsheet files into one

Can anyone out there help me figure out how to best merge 1500 matching spreadsheets for analysis? They have the same columns, in the same folder. I have access to Access, Excel, SharePoint, Word, ...
0
votes
3answers
116 views

Analyse data contained in Excel file

I have been using computers for about 16 years, never used excel or similar software, maybe once. So my excel knowledge is 0. Maybe what I'm about to ask is easy maybe not. The first part of the ...
3
votes
2answers
2k views

Program to import a Microsoft Excel spreadsheet into a MySQL table

I am looking for a program that can: import a Microsoft Excel spreadsheet into a MySQL table support cells containing line breaks support cells containing ' (and if possible any other character) If ...
1
vote
0answers
218 views

Tools to reverse-engineer an Excel spreadsheet

I have at various times been asked to improve some predictive model whose only implementation and documentation is an Excel spreadsheet. What I want instead is a concise set of equations describing ...
1
vote
0answers
346 views

Web application create Excel like grid and store in database

Web application create Excel like grid and store in database I'm looking at a project that will emulate the functions of a Excel worksheet so that an end user can specify cells and headings and what ...
1
vote
1answer
176 views

Software to handle large Excel .xls files

Some users receive XLS files from other offices for analysis, but these files are extremely large and the performance of Excel is low. I know the best solution could be transfer this information to a ...
17
votes
2answers
130 views

Creating a graph of connections between Office files

I'm preparing to move huge amount of files between file servers. The files are located in different shares within one of many servers. I thought it would be good to have clear vision of what is linked ...
2
votes
0answers
123 views

Graphing or charting library that approximates Excel's capabilities?

Moved here from SO, please inform me if need to move elsewhere again. Here's the post: I've been using Excel to manually plot data from CSV to timeseries charts and histograms (with cumulative ...
0
votes
2answers
683 views

Robust c# Excel parsing library

I am looking for a c#/.net excel parsing library that can deal with files uploaded from end users, that may have quirks We are currently using ExcelDataReader but it has some serious shortcomings ...
2
votes
0answers
280 views

Convert Excel to GeoJson in Java

I'm looking for a way to convert an Excel file to a GeoJson file, I looked at GeoTools, found an gt-excel plugin, but I couldn't get it through Maven to try it out. Is there another way ? edit The ...
6
votes
2answers
157 views

How can contacts be shared within a small company (desktop/mobile) and also be usable in office apps

!Hi everyone I would like to ask you guys for advice. Currently I am helping a small organization (4 PC's) to improve their IT system a bit. The main problem is, that each of them is having their ...
5
votes
2answers
76 views

Software (preferable Excel add-in or similar) to abbreviate large number of sentences based on user-set database

We have to take a large number of rows, each containing a text sentence. We need to abbreviate each sentence to have a character length of < 40, as we need to copy-paste the data to SAP which has ...
2
votes
1answer
63 views

Data analysis software connecting to excel

I'm wondering which software would best be suitable for: plotting data, possibly interactive graphics statistics reading and writing excel files (numbers, currencies, enums, dates, possibly text) ...
3
votes
4answers
86 views

Where to start building simple database to streamline analysis for community organization?

I work for a research organization in India and have recently taken up with a program extending immunizations among poor rural communities. They're a fairly large organization but don't really have ...
2
votes
2answers
78 views

Program or library to read an Excel-based schedule hourly and read content out loud

I have an Excel-based hourly schedule that I change and check throughout the day. Is there some tool that would check every hour in the particular day and hour (see column and row) and if there is ...
3
votes
1answer
535 views

What is a good alternative to Zoho Reports?

What other services are similar to Zoho Reports? I performed a search for alternatives and all articles seemed to focus on the CRM and so it was a false comparison. Al the alternatives were about CRM ...
1
vote
0answers
237 views

Printing XLS file programmatically without Excel installed

I have a VB6 application that produces and prints .xls files thanks to an old and deprecated component. It isn't compatible with some of the new printers drivers (makes my application freeze and crash ...
2
votes
2answers
206 views

Web application to convert Excel files to PDF (Separate PDF for each worksheet)

Is there any web application to convert an Excel file with multiple sheets to PDF files? Each sheet will be created as a new PDF file. If I have 3 worksheets in Excel, I'll have 3 PDFs after ...
3
votes
0answers
33 views

What software can be used to create logic from datasets?

I need a software that can import a dataset (excel/CSV table) and I can write formulas/create a workflow logic to export into another (excel/CSV) table. I need this software to be able to be deployed ...
1
vote
0answers
33 views

What is a software for logic and rules management?

I have developed an app that imports excel tables in a specific format and performs analysis on the data. I need to find a software that can Take other excel/csv files and implement database logic ...
2
votes
1answer
1k views

A virtual printer that will print onto a design and then save to computer on Windows

I'm after a piece of software that will show up as a virtual printer (for example how XPS printer shows in Windows in the print dialog) when selected and printed from, it overlays the print content ...
4
votes
1answer
3k views

Picture Viewer to easily copy & paste into MS Office Excel

I need some open/free software for opening pictures with functionality to copy and paste it into another application (Excel in this case). Currently I have to: (1) Right click the file > (2) Edit > (...
1
vote
0answers
242 views

Testing pdf/excel content with C#

Our site has a good number of reports that are using SSRS,Crystal and Excel. We are using C# with Selenium WebDriver. I have been searching for the best practices and best ways and tools to test the ...
6
votes
2answers
862 views

Scan a receipt and recognize text/numeric data on it

I'm looking for a software that can scan a receipt to retrieve data of total price, product's name and price, receipt date and receipt number. Some important criteria: The software can be created as ...
1
vote
0answers
39 views

Exporting all charts from a Microsoft Excel 2013 file as PDFs

I am looking for a program that can export all charts from a Microsoft Excel 2013 file as PDF files. If possible, free, can take a batch of files as input, crop out the surrounding white space and ...
1
vote
4answers
81 views

Tool/macro to make backups of Excel files

I made incorrect changes to an Excel file and saved it, and MS Excel (2003) makes no backup files like MS Word does (only autorecovery files, but that is of no use after clicking 'save'). Is there a ...
6
votes
1answer
877 views

Program to convert Excel 2013 spreadsheets to LaTeX tables

I'm looking for a program or web-service that can convert Microsoft Excel 2013 spreadsheets to LATEX tables And if possible: free works on Windows 7 The package Excel-to-LaTeX only works for Ex­...
1
vote
0answers
76 views

Is there a Microsoft Excel automated (or interactive) "VLOOKUP" program or SaaS where I can combine 2 excel sheets?

I have 2 sheets and I know to use VLOOKUP to cross-reference the sheets and join the data into one sheet. I am wondering if there is an application for windows, or an online SaaS that allows you to ...
1
vote
1answer
71 views

Excel's plugin for Budget?

Information: In a company, there are 6 people who use Excel to create budget. Unfortunately, there are lots of different copy of that file. Problem statement: I'am looking for a plug-in for excel ...
4
votes
1answer
2k views

PHP library to transform Excel .xls .xlsx to OpenDocument .ods

I want to automatically convert Excel files (.xls, .xlsx) to OpenDocument spreadsheets (.ods) Is there a PHP library for that? Or at least a command-line utility that I could call from PHP?
1
vote
1answer
223 views

Sharing an Excel sheet online and edited by more than one user [closed]

I want to share an excel sheet ( Editing Entries, New Entries ) over through online. More than two users will have the rights to do this. I heard of Google docs, but just looking for better option.

1 2
3