Explore Posterous

Microsoft's amazing new data visualization tool Pivot

Loading mentions Retweet

Comment (0) »

Open XLSX Files Without Excel 2007

Loading mentions Retweet

Comment (0) »

Letölthető az Office 2010 Béta a Technet és MSDN előfizetőknek

Letölthető az Excel 2010 bétája TechNet es msdn előfizetőknek. Ezzel elhárult az utolsó akadály is a PowerPivot kipróbálásának útjából.

Az SQL Server 2008 R2 már publikusan (msdn vagy TechNet előfizetés nélkül) is letölthető, az Office esetében erre meg várni kell egy kicsit.

Felhasznált irodalom: http://www.microsoft.com/hun/technet/article/?id=bfebfd53-738a-4d49-88f6-7931589b2d94

Loading mentions Retweet

Axel Font (Spiekermann)

Interessant, dass dieses Wunderwerk auch nicht schmaler läuft als die Calibri (de Groot). Für Excel und Rechnungen aber eine feine Sache.

     

Loading mentions Retweet

Comment (0) »

Elev.at + jQuery = manipulate Excel/Delimited data using JavaScript

Elev.at now supports JSON/P callbacks so you no longer need to proxy XML results from Elev.at via a server to your web app - you can now load the XML directly in the browser.

The JSON/P callback is registered by adding the callback parameter to your lift request.

Here's an example output that lists studios in New York based on the Excel spreadsheet published by the NYC Data Mine.

Loading mentions Retweet

Comment (0) »

Elev.at now with more options

In a previous post, I talked about creating a cloud-based API to convert XLS files to XML. 

The API is now called elev.at and I've added the following new parameters for converting from Excel to XML:

• sheetnumber
• headerrow

 

Loading mentions Retweet

Comment (0) »

Microsoft setzt auf Lockangebot: Neue Windows-Computer mit kostenlosem Office 2010

Leipzig - Briefe verfassen, Bewerbungen schreiben oder Bilanzen erstellen. Kaum ein Computer-Nutzer, der die Vorzüge einer guten Bürosoftware nicht zu schätzen weiß. Dabei hängt es von vielen Faktoren ab, für welches Programm sich die Nutzer entscheiden. Ein Aspekt ist die Marketing-Strategie, über die die Produkte den Kunden erreichen. Das Online-Portal für Auktionen www.auvito.de berichtet in diesem Zusammenhang über Microsofts Strategie zur Markteinführung von Office 2010.

Die Konkurrenz unter den Entwicklern von Bürosoftware ist groß. Nicht erst seit gestern gibt es Alternativen zu Word und Excel, den Programmen für Textverarbeitung und Tabellenkalkulation aus...

Microsoft setzt auf Lockangebot: Neue Windows-Computer mit kostenlosem Office 2010 bei Pressehof komplett lesen

Loading mentions Retweet

Comment (0) »

Béta fázisban az Office 2010

Loading mentions Retweet

Lift legacy Excel data into the Internet age

(EDIT on 10/27/2009: see subsequent post for updates to elev.at)

When the NYC Big Apps competition launched at the beginning of October 2009, I thought, WOW, here is an opportunity to write applications that use data that my city taxes pay for. 

I can deliver something innovative, and maybe even pocket some dollars. The NYC Big Apps website looks fresh, the premise on which the competition is built is strong. 

Until you visit the NYC.gov data mine that is. The data sets are indicated as being updated regularly (depending on the data set, it may be daily, monthly, quarterly, etc.), which is great. 

BUT, the data is served in non-open, non-free, proprietary formats like Excel and Access, instead of JSON or XML.

Several people have complained about the fact that the data sets are in proprietary formats that are hostile to web development, and requires the user to first convert the data to an open format that can be used by development tools. 

To make the data accessible to other developers in a real-time fashion, I created Lifter, which is a REST-ful service that takes a URL to an XLS file, and returns the spreadsheet content in an XML format. 

Elev.at is available at http://elev.at/

and you can convert an XLS file to XML with the query string: xls?{url-to-xls-file}.

For example, to convert the NYC recording studios data set to XML, use this query:

http://elev.at/lift?xls=http://www.nyc.gov/html/film/downloads/excel/MOFTB_Recording_Studios_001.xls

Elev.at returns XML which can be consumed directly in your web application.

An example might be Yahoo! Pipes. Using YQL, you can retrieve an Excel spreadsheet's data and pipe it into other computations:

Of course Lifter is not restricted to the NYC.gov data sets. If you have a URL to an XLS file, you can use Lifter to convert it to XML.

The NYC.gov data mine isn't the only government site that hosts data in hostile formats; Data.gov also serves files in unreadable format in at least 75 instances (as of today). 

But when you thought things couldn't be any worse, it turns out you are wrong. Not only does data.gov serve some data sets in proprietary formats only, they are served as .EXE files (e.g. http://www.data.gov/details/73).  

Hello? 

So if you are the typical hacker who would be writing the innovative apps the government is hoping for (i.e. uses Linux or a Mac), you are locked out of the game.

Loading mentions Retweet

Comment (1) »

highlight alternating rows in excel

http://www.launchpadzero.net/index.php?name=Tips/excel-alternaterows.html

Loading mentions Retweet

Comment (0) »