-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am getting following error while reading from a spreadsheet file. I have searched alot on Google. I have seen posts with similar problems but no reply to the problems. Does anyone know how to resolve this error?
C:/Ruby/lib/ruby/gems/1.8/gems/ruby-ole-1.2.8.2/lib/ole/storage/file_system.rb:125:in…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I need to copy and paste the data from one Excel spreadsheet to another based on column name.
For example, one shreadsheet has columns named like Asset, Asset owner.
Another spreadsheet has column named like Application, Application Owner.
Now I want "Asset" column data to copy and paste into the…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm attempting to clean up data in this (old) spreadsheet and need to remove things like single and double quotes, HTML tags and so on. Trouble is, it's a 3000 row file with 25 columns and every spreadsheet app I've tried (NeoOffice, MS Excel, Apple Numbers) chokes on it. Hard.
Any ideas on how else…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
A common question of users is, How to import the data from the automated data export of Real User Experience Insight (RUEI) into tools for archiving, dashboarding or combination with other sets of data.XML is well-suited for such a translation via the companion Extensible Stylesheet Language Transformations…
>>> More
-
as seen on Programmers
- Search for 'Programmers'
I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting tables, or as an ad-hoc database that could have been maintained in a text-file.
I had to do heavy data-processing…
>>> More