11/26/2024 6:21:29 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Datagrid export to excel - with colours and formats
Posted: 30 Oct 06 4:04 AM
|
fiogf49gjkf0d Hello all, trying to export a datagrid to excel keeping the formats (i.e. dates display as dates rather than numeric values) and colours intact. Now I've come up with something but it's taking far too long checking certain values to grab the date and was just wondering really if anyone knew of any clever tricks to do this without the time consumption. All help appreciated. |
|
|
|
Re: Datagrid export to excel - with colours and formats
Posted: 30 Oct 06 5:57 PM
|
fiogf49gjkf0d What particularly is taking the most time? Are you trying to come to your conclusions using the Excel object or are you trying to use SQL to determine if it's a date?
Any operation that uses the Office objects are going to take time. Because of this you want to do as much processing as possible before you use them. If for instance you're querying Excel row by row to determine if it's a date format, it's going to crawl. If you're trying to determine if a SQL column is a date, there's the adDBTimeStamp type (http://www.devguru.com/technologies/ado/8608.asp) or you can pass the value to the IsDate() VBScript function. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|