teach excel formulas

Old topic. php excel export, phpexcel class is very powerful, but the efficiency is low and slow, fputcsv speed is fast but do not know how to solve the problem of scientific notation, ask the old driver to teach experience such as questions... At present, the exported data may be about million records in the next month. in this case, about 20 M is finally exported. due to the large number of fields, some

Often with Office software to deal with the person must know, if the password of the encrypted document is equivalent to scrap the file, it will be a terrible thing. But mankind is omnipotent, today for you to introduce a software, you can loosen the Word and Excel password, solve your worries. This tool is the Office Password remover. It can crack the passwords of Word and Excel documents in a very short

Tags: Excel SQL bulk Data generation SQL statement databasewhen doing the system or project, often encounter such requirements: the user sent us some data, asked us to import this data into the number ofAccording to the library, for a small amount of data, with the most primitive method can be solved, directly in the SQL with statements to achieve, but if there are thousands ofWhat about the data? If you continue to write SQL statements alone, it is e

for internship in the site or other construction personnel, often need to record the construction management diary, the use of other software can be too complex, the following small series to teach you how to use Excel to make construction management diary. Teach you how to use Excel to make construction management d

Work is always not so free, chatting with QQ for a day like a thief, but playing Excel is no matter. If you want to talk to colleagues for a day or girlfriend just in the same unit how to obedient while look? teach you how to use Excel to chat, to prevent the boss's ace. ★ First Step: Open Excel2003, create a new workbook document, name Save (such as "work recor