Jump to content
mLipok

EXAMPLE: XLS , MDB from scratch with ADOX

Recommended Posts

mLipok

A one user ask about Creating XLS file with ADO.

 

This was interesting to me so I use uncle google and find this:

https://forums.autodesk.com/t5/visual-basic-customization/ado-connection-create-file-excel/td-p/1675928

EDIT: https://msdn.microsoft.com/en-us/library/ms675849(v=vs.85).aspx

 

How you can read in this mentioned above link, This is not posible with ADO but quite easy with ADOX.

Here is AutoIt example:

;~ https://forums.autodesk.com/t5/visual-basic-customization/ado-connection-create-file-excel/td-p/1675928
;~ https://msdn.microsoft.com/en-us/library/ms675849(v=vs.85).aspx

#AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w- 4 -w 5 -w 6 -w 7

Global Const $ADO_adInteger = 3
Global Const $ADO_adVarWChar = 202

#include <Array.au3>
#include <MsgBoxConstants.au3>

_Example()

Func _Example()
    ; Error monitoring. This will trap all COM errors while alive.
    ; This particular object is declared as local, meaning after the function returns it will not exist.
    Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")
    #forceref $oErrorHandler

    Local $oConnection = ObjCreate('ADODB.Connection')
    Local $oCatalog = ObjCreate('ADOX.Catalog')
    Local $oTable = ObjCreate('ADOX.Table')
    ; Local $oColumn = ObjCreate('ADOX.Column')

    $oConnection.open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & @ScriptDir & '\ADOX_EXAMPLE__MyContacts.xls' & ";Extended Properties=Excel 8.0")
    $oCatalog.ActiveConnection = $oConnection

    With $oTable
        .Name = "MyContacts"
        .ParentCatalog = $oCatalog
        
        ; Create fields and append them to the new Table object.
        .Columns.Append("ContactId", $ADO_adInteger)
        .Columns.Append("CustomerID", $ADO_adVarWChar, 16)
        
        ; Make the ContactId column and auto incrementing column
        .Columns("ContactId").Properties("AutoIncrement") = True
                
        ; Create fields and append them to the new Table object.
        .Columns.Append("FirstName", $ADO_adVarWChar, 80)
        .Columns.Append("LastName", $ADO_adVarWChar, 80)
        .Columns.Append("Phone", $ADO_adVarWChar, 20)
        .Columns.Append("Notes", $ADO_adVarWChar)
    EndWith

    $oCatalog.Tables.Append($oTable)

    ;Clean up
    $oConnection.Close

    $oConnection = Null
    ; $oColumn = Null
    $oTable = Null
    $oCatalog = Null
EndFunc    ;==>_Example


; User's COM error function. Will be called if COM error occurs
Func _ErrFunc($oError)
    ; Do anything here.
    ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
            @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
            @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
            @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
            @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc    ;==>_ErrFunc

 

Have fun,
mLipok

Edited by mLipok
Title changed - mdb
  • Like 1

Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
ADO.au3 UDF     POP3.au3 UDF     XML.au3 UDF    How to use IE.au3  UDF with  AutoIt v3.3.14.x  for other useful stuff click the following button

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST API *

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF *

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * 

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2018-03-17

Share this post


Link to post
Share on other sites
mLipok

Some time ago I asked on the forum: how to make SQL Schema comparison of the two databases.
Now Thanks to ADOX I think this is possible to enumerate each DB element and store information about it to XML file.
In that case this will be easy to compare 2 separate XML files at least with WinMerge.
I hope that before the beginning of summer I can do it.

EDIT:
Reference:

https://msdn.microsoft.com/en-us/library/ms254934(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/cc668760(v=vs.110).aspx

 

EDIT2:

Save Recordsets To/Load Recordsets From XML Files Using ADO 2.5:
http://www.freevbcode.com/ShowCode.asp?ID=312

http://www.freevbcode.com/ShowCode.asp?ID=1204

Persisting Records in XML Format
https://msdn.microsoft.com/en-us/library/ms681538(v=vs.85).aspx

Saving to the XML DOM Object
https://msdn.microsoft.com/en-us/library/ms675954(v=vs.85).aspx


Schema Section
https://msdn.microsoft.com/en-us/library/ms675943(v=vs.85).aspx

 

Hierarchical Recordsets in XML
https://msdn.microsoft.com/en-us/library/ms676166(v=vs.85).aspx

Edited by mLipok

Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
ADO.au3 UDF     POP3.au3 UDF     XML.au3 UDF    How to use IE.au3  UDF with  AutoIt v3.3.14.x  for other useful stuff click the following button

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST API *

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF *

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * 

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2018-03-17

Share this post


Link to post
Share on other sites
mLipok

Here is new version of this example. Now also with MS ACCESS file:

;~ https://forums.autodesk.com/t5/visual-basic-customization/ado-connection-create-file-excel/td-p/1675928
;~ https://msdn.microsoft.com/en-us/library/ms675849(v=vs.85).aspx

#AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w- 4 -w 5 -w 6 -w 7

Global Const $ADO_adInteger = 3
Global Const $ADO_adVarWChar = 202
Global Const $ADOX_adPermObjTable = 1 ; The object is a table.
Global Const $ADOX_adAccessRevoke = 4 ; Any explicit access rights of the group or user will be revoked.
Global Const $ADOX_adRightFull = 268435456 ;            (&H10000000)The user or group has all permissions on the object.

#include <Array.au3>
#include <MsgBoxConstants.au3>

_Example_XLS()
_Example_ACCESS()

Func _Example_XLS()
    ; Error monitoring. This will trap all COM errors while alive.
    ; This particular object is declared as local, meaning after the function returns it will not exist.
    Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")
    #forceref $oErrorHandler

    Local $oConnection = ObjCreate('ADODB.Connection')
    Local $oCatalog = ObjCreate('ADOX.Catalog')
    Local $oTable = ObjCreate('ADOX.Table')
    ; Local $oColumn = ObjCreate('ADOX.Column')

    $oConnection.open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & @ScriptDir & '\ADOX_Example_XLS__MyContacts.xls' & ";Extended Properties=Excel 8.0")
    $oCatalog.ActiveConnection = $oConnection

    With $oTable
        .Name = "MyContacts"
        .ParentCatalog = $oCatalog

        ; Create fields and append them to the new Table object.
        .Columns.Append("ContactId", $ADO_adInteger)
        .Columns.Append("CustomerID", $ADO_adVarWChar, 16)

        ; Make the ContactId column and auto incrementing column
        .Columns("ContactId").Properties("AutoIncrement") = True

        ; Create fields and append them to the new Table object.
        .Columns.Append("FirstName", $ADO_adVarWChar, 80)
        .Columns.Append("LastName", $ADO_adVarWChar, 80)
        .Columns.Append("Phone", $ADO_adVarWChar, 20)
        .Columns.Append("Notes", $ADO_adVarWChar)
    EndWith

    $oCatalog.Tables.Append($oTable)

    ;Clean up
    $oConnection.Close

    $oConnection = Null
    ; $oColumn = Null
    $oTable = Null
    $oCatalog = Null
EndFunc   ;==>_Example_XLS

Func _Example_ACCESS()
    ; Error monitoring. This will trap all COM errors while alive.
    ; This particular object is declared as local, meaning after the function returns it will not exist.
    Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")
    #forceref $oErrorHandler

    ; https://msdn.microsoft.com/en-us/library/ms680934(v=vs.85).aspx
    Local $oCatalog = ObjCreate('ADOX.Catalog')
    Local $oTable = ObjCreate('ADOX.Table')
    ; Local $oColumn = ObjCreate('ADOX.Column')

    FileDelete('Example_from_AutoIt.mdb')
;~  Local $sConnectionString = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Data Source=Example_from_AutoIt.mdb"
;~  Local $sConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Data Source=Example_from_AutoIt.mdb"
;~  Local $sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Example_from_AutoIt.mdb"
    Local $sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Example_from_AutoIt.mdb"
    Local $oConnection = $oCatalog.Create($sConnectionString)
    With $oTable
        .Name = "MyContacts"
        .ParentCatalog = $oCatalog

        ; Create fields and append them to the new Table object.
        .Columns.Append("ContactId", $ADO_adInteger)
        .Columns.Append("CustomerID", $ADO_adVarWChar, 16)

        ; Make the ContactId column and auto incrementing column
        .Columns("ContactId").Properties("AutoIncrement") = True

        ; Create fields and append them to the new Table object.
        .Columns.Append("FirstName", $ADO_adVarWChar, 80)
        .Columns.Append("LastName", $ADO_adVarWChar, 80)
        .Columns.Append("Phone", $ADO_adVarWChar, 20)
        .Columns.Append("Notes", $ADO_adVarWChar)
    EndWith

    $oCatalog.Tables.Append($oTable)

    #Region something not working here yet - work in progress
    ; Groups and Users Append, ChangePassword Methods Example (VB)
    ; https://msdn.microsoft.com/en-us/library/ms678350(v=vs.85).aspx
;~  Local $oUser = ObjCreate('ADOX.User')
;~  $oUser.Name = 'AutoIt'
;~  $oUser.ChangePassword("", "Forum")
;~  Local $oUsers_coll = $oCatalog.Users
;~  $oUsers_coll.Refresh()
;~  MsgBox(0, '', $oUsers_coll.Count)
;~  $oCatalog.Groups.Append("Accounting")
;~  $oCatalog.Users.Append("AutoIt2","Forum")

    ; GetPermissions and SetPermissions Methods Example (VB)
    ; https://msdn.microsoft.com/en-us/library/ms677537(v=vs.85).aspx
;~  $oCatalog.Users("AutoIt").SetPermissions("MyContacts", $ADOX_adPermObjTable, $ADOX_adAccessRevoke, $ADOX_adRightFull)
    #EndRegion something not working here yet - work in progress

    ;Clean up
    $oConnection.Close

    $oConnection = Null
    $oTable = Null
    $oCatalog = Null
EndFunc   ;==>_Example_ACCESS

; User's COM error function. Will be called if COM error occurs
Func _ErrFunc($oError)
    ; Do anything here.
    ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
            @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
            @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
            @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
            @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc   ;==>_ErrFunc

 


Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
ADO.au3 UDF     POP3.au3 UDF     XML.au3 UDF    How to use IE.au3  UDF with  AutoIt v3.3.14.x  for other useful stuff click the following button

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST API *

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF *

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * 

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2018-03-17

Share this post


Link to post
Share on other sites
Skysnake

:)

 

 

 

Edited by Skysnake

Skysnake

Why is the snake in the sky?

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

  • Similar Content

    • Ahmed101
      By Ahmed101
      I have more than 12 workbooks opened together, if i wanted to attach to the last workbook opened it will take more than 1 minute !
      Is there any solution for that ?
    • Daniza
      By Daniza
      Hello! where should I start, if I want to have a Progress Bar while waiting for my File to be open, can I use WinWaitActive? Thanks,
    • Evolutionnext
      By Evolutionnext
      I am still a noob and not a programmer, would greatly appreciate your help.
       
      Task:
      Open Excel file with file path and name: C:\Users\GENOBEAUTYPC1\Desktop\ACTIVE BEAUTY LABELS\BeautyMe Label 200ml ACTIVE VERSION.xlsx
      This file path and name is saved in the variable: $sAnswer
      Go to Excel Tab called "formular"
      Go to Cell A1
      Insert the text saved in the variable: $sAnswer2
      ATTENTION!!! This has 2 problems.
      Problem number 1: This text contains special characters that need to be interpreted as raw text. (content is: Gemischt für#30 ml#Mindestens haltbar bis#Maria Wallerstorfer#Anwendung: Täglich 1x morgens auf das gereinigte Gesicht auftragen. Augenkontakt vermeiden.#Über 0 C° und unter 25 C° lagern.#Lot:N8A1028/D30/V2.1#Genome Plus GmbH#Georg-Wrede-St. 13, D-83395 Freilassing#GEN SERUM#DAY)
      Problem number 2: This textis longer than 255 characters.
       
      Can anyone help me?
       
      I try to do it really primitively by opening the excel, waiting until it is open, clicking where the tab is, clicking where the cell is and inserting the content of the variable, but I am stuck at the point where I am limited by 255 characters.
       

      ; Opening the right excel FileChangeDir
                  tooltip("File exists and is called:"&$sAnswer ,300,300)
                  ShellExecute($sAnswer ,"" ,"" ,"" , @SW_MAXIMIZE)
                  sleep(7000)
                  
                  tooltip("Now lets insert the right content into the excel",300,300)
                  MouseClick("left",226,1004)
                  MouseClick("left",52,179)
                  sleep(500)
                  Send("A1")
                  sleep(500)
                  send("{enter}")
                              tooltip("inserting label content",300,300)
                  sleep(500)
                  Send($sAnswer2,  1)
                                          tooltip("inserting INCIS",300,300)
                  sleep(5000)
                  Send($sAnswer3, 1)
                  sleep(5000)
       
       
       
    • AzgarD
      By AzgarD
      Hi guys. I know this is a newbie topic, very newbie, but i've read a lot of stuff and still don't get it. I just need to copy something from Excel cell, paste this in other program, copy something in this program and paste in other Excel cell. Something like...
      Copy A2 Use some WindowActivate and MouseMove stuff and CTRL+C (not a problem) Go back to the Excel sheet Paste that content in C2 Then Copy A3 Use some WindowActivate and MouseMove stuff and CTRL+C (not a problem) Go back to the Excel sheet Paste that content in C3 ... And it goes on The problem is, how can i "communicate" with Excel and do this row change? Like A2 to C2 and A3 to C3 ... In a efficient way that can be done like hundreds of times.
      Very newbie question but still not understanding this.
       
      Ty guys.
    • Gowrisankar
      By Gowrisankar
      Dear members of the forum,
      I need to open excel files that may or may not need a password and finally move the files that needs password to manual queue.
      Is there a fastest way to do this?
       
      PS: I have a huge respect for the rules of this forum. I am not asking assistance to override any security measure. I just need to segregate the files that needs passwords.
×