Editores de planilhas como o Microsoft Excel, do tradicional pacote Microsoft Office, não servem apenas para fazer tabelas simples. Os programas possuem funções matemáticas embutidas que permitem fazer cálculos complexos e extrair o máximo possível de dados diferentes de forma automática.
Busca pela tag "excel"
The ApacheSW Jakarta POI project, located at http://jakarta.apache.org/poi/ is a JavaSW library that allow you to manipulate Microsoft document formats. Within the POI project, POI-HSSF allows you to read, modify, and write Excel documents. The HSSF Quick Guide at http://jakarta.apache.
Formatting, such as currency, alignment, and color, determines how Excel displays a value. But conditional formatting is more flexible, applying specified formatting only when certain conditions are met. Here are some creative ways you can push conditional formatting beyond its expected uses.
I want to cover something today that I use all of the time but seems to be understood in varying degrees by clients I work with. I am talking about use of the dollar sign ($) in an Excel formula.
Most of the time my clients need to download data from their database tables. Exporting to CSV is a pain in the rear for users and it leads to confusion (you know the colon and semicolon stuff).