Jump to content
Sign in to follow this  
acidman

Excel cells

Recommended Posts

acidman

Hi there...

How do you write data to 2 excel cells or extended the length of a cell Because when I write a numerical string Longer Than 12 characters it makes it some weird formula. any help?


[u]My dream is to have a dream...[/u]

Share this post


Link to post
Share on other sites
water

Weird formula? You are talking about floating point numbers. Either change the format of the cells so they are displayed as integers or enter them as text.

Text means

_ExcelWriteCell($oExcel, "'1234567890123456", 1, 1)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
acidman

yea see I'm busy developing software so the code is a bit too huge to display as a spoiler. if I get the number from an Input box "9012494654654654" and write it tp an xls document but it gives me a weird formula when I view The xls file it doesnt display the number.


[u]My dream is to have a dream...[/u]

Share this post


Link to post
Share on other sites
water

Try something like this:

$sInput = InputBox(....)
_ExcelWriteCell($oExcel, "'" & $sInput, 1, 1)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
acidman

Thanks A lot my man, I appreciate it dearly!


[u]My dream is to have a dream...[/u]

Share this post


Link to post
Share on other sites
water

Glad to be of service :oops:

N.B. Now the cells content is handled as a string by Excel. So for later calculations you have to convert it to a number or instead of writing the number as text to Excel the formatting of the cell has to be changed.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

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  

×