Sign in to follow this  
Followers 0
golfinhu

Excel cell format!

4 posts in this topic

#1 ·  Posted (edited)

I have a problem with Excel, can someone help me?

In the first code, why the zero is not written in the cell?

#include <Excel.au3>
Local $oExcel = _ExcelBookNew() ;Create new book, make it visible
For $i = 1 To 10 ;Loop
    _ExcelWriteCell($oExcel, "0" & Random(1,99, 1), $i, 1)
    _ExcelWriteCell($oExcel, "0" & Random(1,99, 1), $i, 2)
Next
Sleep(3000)
_ExcelBookClose($oExcel) ; And finally we close out

and if i try read a cell that is initiated by zero, excel do not bring that zero too! =/

I just need to know how to get and write zeros in excel! (in first position)

Thanks a lot!

Edited by golfinhu

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

First code: Excel doesn't like leading zeros. If you open a sheet & type "048" you get "48".

If you change _ExcelWriteCell($oExcel, "0" & Random(1,99, 1), $i, 1) to

_ExcelWriteCell($oExcel, ".0" & Random(1,99, 1), $i, 1) (note the decimal before the zero)

then it writes the zero.

This answers the "why" question but unfortunately gives no "how".

Edit: _ExcelWriteCell($oExcel, "'0" & Random(1,99, 1), $i, 1) using an apostrophe before the zero

This gets you a zero without the unwanted decimal.

http://www.techrepublic.com/blog/msoffice/entering-leading-zeroes-in-excel/2360

Edited by lorenkinzel

Share this post


Link to post
Share on other sites

Store it as text instead of as a number use "'0", put a single quote in front of the number that starts with 0 and it will be stored in the cell as text.


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

Thanks a lot lorenkinzel and BrewManNH

It works perfectly!

now i only need know how to i get it from excel ;p

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0