Help, I’ve Received a Spreadsheet File from StarOffice Calc…..!

£0.00

  • VIEWS Independent UK SAS User Group, London, UK – 20th May 2004

Abstract

We have been conditioned to accept spreadsheet files from Excel, which require SAS/ACCESS to
read (unless they have been saved as delimited files). When a spreadsheet file is sent to us from
StarOffice, or OpenOffice.org, Calc, we are likely to panic, but we should not even break into a
sweat, as Base SAS is more than enough to read all the data from this compressed XML format.

This paper will show you how to read text, numbers, percentages, currency values, dates and times
from this spreadsheet file format. If you want you will even be able to read the formulae too!

Description

Loading

  • VIEWS Independent UK SAS User Group, London, UK – 20th May 2004

Abstract

We have been conditioned to accept spreadsheet files from Excel, which require SAS/ACCESS to
read (unless they have been saved as delimited files). When a spreadsheet file is sent to us from
StarOffice, or OpenOffice.org, Calc, we are likely to panic, but we should not even break into a
sweat, as Base SAS is more than enough to read all the data from this compressed XML format.

This paper will show you how to read text, numbers, percentages, currency values, dates and times
from this spreadsheet file format. If you want you will even be able to read the formulae too!

Reviews

There are no reviews yet.

Be the first to review “Help, I’ve Received a Spreadsheet File from StarOffice Calc…..!”

This site uses Akismet to reduce spam. Learn how your comment data is processed.