|
!Langage!!Référence/ pointeur nul!!Test nul!!Chaîne de caractère<br/>Caractère!!Entier!!Flottant!!Booléen!!Allocation/libération mémoire
|-
|[[Programmation Ada|Ada]] || <ttcode></ttcode> || <ttcode></ttcode> || <ttcode>"Un exemple accentué à moins de 1."<br/>'E'</ttcode> || <ttcode>512 0x200 -123</ttcode> || <ttcode>3.14 314.159E-2</ttcode> || <ttcode>False True</ttcode> || allocation : <ttcode></ttcode><br/>libération : <ttcode></ttcode>
|-
|[[Programmation C|C]] || <ttcode>(void*)0</ttcode> || <ttcode></ttcode> || <ttcode>"Un exemple accentué à moins de 1\x80."<br/>'E'</ttcode> || <ttcode>512 0x200 -123</ttcode> || <ttcode>3.14 314.159E-2</ttcode> || <ttcode>0 1</ttcode> || allocation : <ttcode>''ptr'' = malloc(''size'')</ttcode><br/>libération : <ttcode>free(''ptr'')</ttcode>
|-
|[[Programmation Java|Java]] || <ttcode>null</ttcode> || <ttcode>isEmpty()</ttcode> || <ttcode>"Un exemple accentué à moins de 1\u20AC."<br/>'E'</ttcode> || <ttcode>512 0x200 -123</ttcode> || <ttcode>3.14 3.14D 314.159E-2</ttcode> || <ttcode>false true</ttcode> || allocation : <ttcode>''ref'' = new ''class''(''arguments...'')</ttcode><br/>libération : <ttcode>''ref'' = null; /* garbage collector */</ttcode>
|-
|[[Programmation JavaScript|JavaScript]] || <ttcode>null</ttcode> || <ttcode>typeof X != 'undefined'</ttcode> ||
|-
|[[Programmation Pascal|Pascal]] || <ttcode>nil</ttcode> || <ttcode></ttcode> || <ttcode>'Un exemple accentué à moins de 1.'<br/>'E'</ttcode> || <ttcode>512 $200 -123</ttcode> || <ttcode>3.14 314.159E-2</ttcode> || <ttcode>False True</ttcode> || allocation : <ttcode></ttcode><br/>libération : <ttcode></ttcode>
|-
|[[Programmation PHP|PHP]] || <ttcode>null</ttcode> || <ttcode>is_null()</ttcode><br/><ttcode>isset()</ttcode><br/><ttcode>function_exists()</ttcode> || || || || <ttcode>False True</ttcode> ||
|-
|[[Programmation Python|Python]] || <ttcode>null</ttcode> || <ttcode>is None</ttcode> || || || || <ttcode>False True</ttcode> ||
|-
|[[Programmation VBA|VBA]] || <ttcode>null</ttcode> || <ttcode>isEmpty()</ttcode> || || || || <ttcode>False True</ttcode> ||
|-
|[[Programmation SQL|SQL]] || <ttcode>NULL</ttcode> || MySQL : <ttcode>isnull()</ttcode>, <ttcode>ifnull()</ttcode><br/>MSSQL : <ttcode>isnull()</ttcode> || || || || <ttcode>False True</ttcode> ||
|}
!Langage!!Bloc d'instructions!!Condition simple!!Condition à cas multiples!!Boucles!!Sous-programmes!!Module!!Programme principal!!Capture d'exception
|-
|[[Windows PowerShell]] ([[DOS]]) || <ttcode>(</ttcode><br/>...<br/><ttcode>)</ttcode> || <ttcode>if</ttcode> ...condition... ...commande... else ...commande... || <!--switch--> || for %%var in ( liste_ou_file_pattern ) do ... || call :nom ...<br/>...<br/>:nom<br/>...<br/>goto :eof || <!--module_unite--> || ''séquence des commandes du fichier'' ||
|-
| [[Programmation Shellscript|Shell Unix]] || <!--bloc--> || if<br/>...<br/>fi || <!--switch--> || <!--while_for_loop_repeat--> || <!--fonctions_procedure--> || <!--module_unite--> || ''séquence des commandes du fichier'' ||
|-
| [[Python]] || <fontspan colorstyle="color:red">''indentation''</fontspan> || if ... :<br/>...<br/>elif ... :<br/>...<br/>else: || <!--switch--> || while ... :<br/>for ... : || <!--fonctions_procedure--> || <!--module_unite--> || <!--main--> || try:<br/>...<br/>except ... :<br/>...<br/>
|-
| [[Programmation Ada|Ada]] || <ttcode>begin</ttcode><br/>...<br/><ttcode>end;</ttcode> || <ttcode>if (</ttcode>...<ttcode>) then</ttcode> ...<br/><ttcode>elsif (</ttcode>...<ttcode>) then</ttcode> ...<br/>...<br/><ttcode>else</ttcode> ...<br/><ttcode>end if;</ttcode> || <ttcode>case (</ttcode>...<ttcode>)</ttcode><br/><ttcode>when </ttcode>...<ttcode> => ...</ttcode><br/><ttcode>when others => ...</ttcode><br/><ttcode>end case;</ttcode> || <ttcode>while (</ttcode>...<ttcode>) loop</ttcode><br/>...<br/><ttcode>end loop;</ttcode> || <ttcode>function </ttcode>''nom''<ttcode>(</ttcode>parametre<ttcode>:</ttcode>type<ttcode>;</ttcode>...<ttcode>) return </ttcode>''type''<ttcode> is</ttcode><br/>...<br/><ttcode>begin</ttcode><br/>...<br/><ttcode>return </ttcode>...<ttcode>;</ttcode><br/><ttcode>end;</ttcode><br/><br/><ttcode>procedure </ttcode>''nom''<ttcode>(</ttcode>parametre<ttcode>:</ttcode>(<ttcode>in</ttcode>/<ttcode>out</ttcode>/<ttcode>in out</ttcode>) type<ttcode>;</ttcode>...<ttcode>) is</ttcode><br/>...<br/><ttcode>begin</ttcode><br/>...<br/><ttcode>end;</ttcode> || '''nom.ads (spécification) :'''<br/><ttcode>package </ttcode>''nom''<ttcode> is</ttcode><br/>...<br/><ttcode>end </ttcode>''nom''<ttcode>;</ttcode><br/>'''nom.adb (corps) :'''<br/><ttcode>package body </ttcode>''nom''<ttcode> is</ttcode><br/>...<br/><ttcode>end </ttcode>''nom''<ttcode>;</ttcode><br/>'''utilisation :'''<br/><ttcode>with </ttcode>''package,...''<ttcode>; -- déclarer</ttcode><br/><ttcode>use </ttcode>''package,...''<ttcode>; -- utiliser l'espace de nom</ttcode> || <ttcode>procedure </ttcode>''nom''<ttcode> is</ttcode><br/>...<br/><ttcode>begin</ttcode><br/>...<br/><ttcode>end;</ttcode> ||
|-
| [[Pascal]] || <ttcode>begin</ttcode><br/>...<br/><ttcode>end;</ttcode> || <ttcode>if </ttcode>...<ttcode> then</ttcode> ...<br/><ttcode>else if </ttcode>...<ttcode> then</ttcode> ...<br/>...<br/><ttcode>else</ttcode> ... || <ttcode>case </ttcode>...<ttcode> of</ttcode><br/>...<ttcode> : ...</ttcode><br/><ttcode>else ...</ttcode><br/><ttcode>end;</ttcode> || <ttcode>while </ttcode>...<ttcode> do </ttcode>...<br/><br/><ttcode>repeat</ttcode><br/> ...<br/><ttcode>until </ttcode>...<ttcode>;</ttcode><br/><br/><br/><ttcode>for </ttcode><i>var</i><ttcode> := </ttcode><i>start</i><ttcode> to </ttcode><i>end</i><ttcode> do </ttcode>...<br/><ttcode>for </ttcode><i>var</i><ttcode> := </ttcode><i>start</i><ttcode> downto </ttcode><i>end</i><ttcode> do </ttcode>...<br/> || <ttcode>function </ttcode>''nom''<ttcode>(</ttcode>parametre<ttcode>:</ttcode>type<ttcode>;</ttcode>...<ttcode>) : </ttcode>''type''<ttcode>;</ttcode><br/>...<br/><ttcode>begin</ttcode><br/>...<br/>''nom''<ttcode> := </ttcode>...<ttcode>;</ttcode><br/><ttcode>end;</ttcode><br/><br/><ttcode>procedure </ttcode>''nom''<ttcode>(</ttcode>parametre<ttcode>:</ttcode>type<ttcode>;</ttcode>...<ttcode>);</ttcode><br/>...<br/><ttcode>begin</ttcode><br/>...<br/><ttcode>end;</ttcode> || <ttcode>unit </ttcode>''nom''<ttcode>;</ttcode><br/><ttcode>interface</ttcode><br/>...<br/><ttcode>implementation</ttcode><br/>...<br/><ttcode>end.<br/>'''utilisation :'''<br/><ttcode>uses </ttcode>''unité,...''<ttcode>;</ttcode> || <ttcode>program </ttcode>''nom''<ttcode>;</ttcode><br/>...<br/><ttcode>end.</ttcode> ||
|-
| [[Programmation C|C]] || <ttcode>{</ttcode><br/>...<br/><ttcode>}</ttcode> || <ttcode>if (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>else if (</ttcode>...<ttcode>)</ttcode> ...<br/>...<br/><ttcode>else</ttcode> ... || <ttcode>switch(</ttcode>...<ttcode>)</ttcode><br/><ttcode>{</ttcode><br/><ttcode>case</ttcode> ...<ttcode>:</ttcode>...<br/>...<br/><ttcode>default:</ttcode>...<br/><ttcode>}</ttcode> || <ttcode>while (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>do </ttcode> ...<ttcode> while (</ttcode>...<ttcode>);</ttcode><br/><ttcode>for (</ttcode>...<ttcode>;</ttcode>...<ttcode>;</ttcode>...<ttcode>)</ttcode> ... || ''type_retour'' ''nom''(type param,...){...} || '''utilisation :'''<br/><ttcode>#include </ttcode>''fichier'' || <ttcode>int main(int argc, char** argv)</ttcode><br/><ttcode>{ ... }</ttcode> || style="background-color: gray;" |
|-
| [[:Catégorie:C++|C++]] || <ttcode>{</ttcode><br/>...<br/><ttcode>}</ttcode> || <ttcode>if (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>else if (</ttcode>...<ttcode>)</ttcode> ...<br/>...<br/><ttcode>else</ttcode> ... || <ttcode>switch(</ttcode>...<ttcode>)</ttcode><br/><ttcode>{</ttcode><br/><ttcode>case</ttcode> ...<ttcode>:</ttcode>...<br/>...<br/><ttcode>default:</ttcode>...<br/><ttcode>}</ttcode> || <ttcode>while (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>do </ttcode> ...<ttcode> while (</ttcode>...<ttcode>);</ttcode><br/><ttcode>for (</ttcode>...<ttcode>;</ttcode>...<ttcode>;</ttcode>...<ttcode>)</ttcode> ... || ''type_retour'' ''nom''(type param,...){...} || '''utilisation :'''<br/><ttcode>#include </ttcode>''fichier''<br/><ttcode>using namespace </ttcode>''namespace''<ttcode>;</ttcode> || <ttcode>int main(int argc, char** argv)</ttcode><br/><ttcode>{ ... }</ttcode> || <ttcode>try { ... }<br/>catch(''type var'') { ... }</ttcode>
|-
| [[PHP]] || <ttcode>{</ttcode><br/>...<br/><ttcode>}</ttcode> || <!--if--> || <!--switch--> || <!--while_for_loop_repeat--> || <!--fonctions_procedure--> || <!--module_unite--> || <!--main--> || <ttcode>try { ... }<br/>catch { ... }</ttcode>
|-
| [[Programmation Java|Java]] || <ttcode>{</ttcode><br/>...<br/><ttcode>}</ttcode> || <ttcode>if (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>else if (</ttcode>...<ttcode>)</ttcode> ...<br/>...<br/><ttcode>else</ttcode> ... || <ttcode>switch(</ttcode>...<ttcode>)</ttcode><br/><ttcode>{</ttcode><br/><ttcode>case</ttcode> ...<ttcode>:</ttcode>...<br/>...<br/><ttcode>default:</ttcode>...<br/><ttcode>}</ttcode> || <ttcode>while (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>do </ttcode> ...<ttcode> while (</ttcode>...<ttcode>);</ttcode><br/><ttcode>for (</ttcode>...<ttcode>;</ttcode>...<ttcode>;</ttcode>...<ttcode>)</ttcode> ... || ''type_retour'' ''nom''(type param,...){...} || '''Déclaration (1ère ligne) :'''<br/><ttcode>package </ttcode>''package''<ttcode>;</ttcode><br/>'''utilisation :'''<br/><ttcode>import </ttcode>''package.(classe ou *)''<ttcode>;</ttcode> || <ttcode>public static void main(String[] args)</ttcode><br/><ttcode>{ ... }</ttcode> || <ttcode>try { ... }<br/>catch(''type var'') { ... }<br/>finally { ... }</ttcode>
|-
| [[Programmation JavaScript|JavaScript]] || <ttcode>{</ttcode><br/>...<br/><ttcode>}</ttcode> || <ttcode>if (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>else if (</ttcode>...<ttcode>)</ttcode> ...<br/>...<br/><ttcode>else</ttcode> ... || <ttcode>switch(</ttcode>...<ttcode>)</ttcode><br/><ttcode>{</ttcode><br/><ttcode>case</ttcode> ...<ttcode>:</ttcode>...<br/>...<br/><ttcode>default:</ttcode>...<br/><ttcode>}</ttcode> || <ttcode>while (</ttcode>...<ttcode>)</ttcode> ...<br/><ttcode>do </ttcode> ...<ttcode> while (</ttcode>...<ttcode>);</ttcode><br/><ttcode>for (</ttcode>...<ttcode>;</ttcode>...<ttcode>;</ttcode>...<ttcode>)</ttcode> ... || function ''nom''(param,...){...} || <!--module_unite--> || ''séquence des commandes du fichier'' || <ttcode>try { ... }<br/>catch(''var'') { ... }</ttcode>
|-
| [[Visual Basic]] || <fontspan colorstyle="color:red">''rien''</fontspan> || if ... then<br/>...<br/>elseif ... then<br/>...<br/>end if || <!--switch--> || while ... wend<br/>do while ... loop<br/>for ... next || call || <!--module_unite--> || <!--main--> || <ttcode>on error resume next<br/>...<br/>on error goto 0</ttcode>
|-
| LibO [[OpenOffice.org|Basic]] || <fontspan colorstyle="color:red">''rien''</fontspan> || if ... then<br/>...<br/>elseif ... then<br/>...<br/>end if || <!--switch--> || while ... wend<br/>do while ... loop<br/>for ... next || <!--fonctions_procedure--> || <!--module_unite--> || <!--main--> ||
|}
=== Commentaires et commandes de bases ===
{| class="wikitable sortable" border="1" style="text-align: center" style="border:2px solid black;"
!Langage!!<fontspan sizestyle=1"font-size:0.63em">Ligne de commentaire</fontspan>!!<fontspan sizestyle=1"font-size:0.63em">Bloc de commentaire</fontspan>!!<fontspan sizestyle=1"font-size:0.63em">Écha-<br>ppement</fontspan>!!Afficher!!Saisir!!Déclaration!!Définition!!Égal!!Différent!!Et!!Ou
|-
|[[Windows PowerShell]] ([[DOS]]) || rem || <# ... #> || ^ || echo || pause, SET /P variable=[promptString], ''choix multiple :'' choice, ''copie :'' copy con || ''variable :'' set, ''fichier :'' cp, copy, xcopy || = ''(on appelle ensuite les variables avec %variable%)'' || ==, EQU || !==!, NEQ || -and<ref>http://www.powershellpro.com/powershell-tutorial-introduction/powershell-tutorial-conditional-logic/</ref> || -or
| [[Programmation Bash/Commandes shell|Shell Unix]]|| # || : <<'END'...END || \ || echo || sleep, read || ''fichier :'' touch, cp, mv || = || = || != || && || <nowiki>||</nowiki>
|-
| [[Python]] || # || <nowiki>'''...''', """..."""</nowiki> || \ || print || raw_input() || <fontspan colorstyle="color:red">''rien''</fontspan> || def || == || != || and || or
|-
| [[Programmation Ada|Ada]] || -- || <fontspan colorstyle="color:red">''rien''</fontspan> || \ || Put(), Put_Line() || Get(), GetLine() || ''variable:type'' || := || = || /= || and || or
|-
| [[Pascal]] || <fontspan colorstyle="color:red">''rien''</fontspan> || {...} ou (*...*) || Chr() || Write(), Writeln() || Read(), Readln() || var ''variable:type'' || := || = || <> || and || or
|-
| [[Programmation C|C]] || <fontspan colorstyle="color:red">''rien''</fontspan> || /*...*/ || \ || printf(), fprintf(), sprintf(), puts() || scanf() || ''voir le paragraphe [[Translinguisme/Programmation#Types|types]]'' || =, ''adresse de pointeurs :'' == || == || != || && || <nowiki>||</nowiki>
|-
| [[:Catégorie:C++|C++]] || // || /*...*/ || \ || cout<< || cin>> || ''voir le paragraphe [[Translinguisme/Programmation#Types|types]]'' || =, ''adresse de pointeurs :'' == || == || != || && || <nowiki>||</nowiki>
| [[Programmation JavaScript|JavaScript]] || // || /*...*/ || \ || alert() || prompt() || var || = || == || != || && || <nowiki>||</nowiki>
|-
| [[Le langage HTML|HTML]] || <nowiki><!--...--></nowiki> || <nowiki><!--...--></nowiki> || & || <fontspan colorstyle="color:red">''rien''</fontspan> || <nowiki><input></nowiki> || <fontspan colorstyle="color:red">''rien''</fontspan> || = || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan>
|-
| [[SQL]] || --, <br>''Oracle : rem, @<ref>http://www.querytool.com/help/1135.htm</ref> || <nowiki>/*...*/</nowiki> || " || select || print || ''table :'' create table || ''variable :'' :, ''table :'' update, insert || = || not || and || or
|-
| [[Visual Basic]] || ', rem || <fontspan colorstyle="color:red">''rien''</fontspan> || " || MsgBox || InputBox || ''variable :'' dim <br>''fonction :'' sub || =, ''fichier :'' .CopyFile<br/> ''fichier, feuille :'' .new || = || <> || and || or
|-
| LibO [[OpenOffice.org|Basic]] || ', rem || <fontspan colorstyle="color:red">''rien''</fontspan> || " || MsgBox || InputBox || ''variable :'' dim <br>''fonction :'' sub || = || = || <> || and<ref>http://wiki.services.openoffice.org/wiki/FR/Documentation/BASIC_Guide/Operators</ref> || or
|}
=== Syntaxe et traitement de chaînes ===
{| class="wikitable sortable" border="1" style="text-align: center" style="border:2px solid black;"
!Langage!!<span style="font -size=1:0.63em">Retour à la ligne</fontspan>!!Concaténation!!Wildcard!!Classer!!Longueur!!Majuscule!!Minuscule!!Rechercher dans une chaîne!! Rechercher remplacer !! Tronquer une chaîne !! Rogner
|-
|[[Windows PowerShell]] ([[DOS]]) || \r\n || ''commandes traitant le résultat de la précédente :'' <nowiki>|</nowiki> || * || sort /r || || || || || || ||
|-
| [[Python]] || \n \r ou \r\n <ref name="osnl">Le retour à la ligne dépend du système d'exploitation et pas du langage de programmation dont le compilateur ou interpréteur peut être capable d'accepter les trois séquences possibles afin de réutiliser des codes sources provenant de systèmes différents :
* <ttcode>\n</ttcode> pour Unix, Linux
* <ttcode>\r</ttcode> pour Mac OS
* <ttcode>\r\n</ttcode> pour DOS, Windows
</ref> || + || * || sort() || len() || .upper() || .lower() || .find()<br/>''inverse :'' .rfind() || .replace() || [] || .strip()
|-
| [[Programmation Ada|Ada]] || \n \r ou \r\n <ref name="osnl"/> || ''chaines :'' <ttcode>&</ttcode>'', commandes :'' ; || * || Gnat.Heap_Sort_G<ref>http://rosettacode.org/wiki/Sort_an_integer_array#Ada</ref> || ''variable''<ttcode>'Size</ttcode> || <ttcode>Characters. Handling. To_Upper()</ttcode> || <ttcode>Characters. Handling. To_Lower()</ttcode> || || || ''chaîne''<ttcode>(</ttcode>''début''<ttcode>..</ttcode>''fin''<ttcode>)</ttcode>
|-
| [[Programmation C|C]] || \n \r ou \r\n <ref name="osnl"/> || ''chaines :'' strcat'', commandes :'' , || *, ''déclaration :'' ... || qsort() || sizeof || -=32 || +=32 || strpbrk(), strchr() || || strncat()
| [[Programmation JavaScript|JavaScript]] || \n \r ou \r\n <ref name="osnl"/> || + || * || sort() || .length || .toUpperCase() || .toLowerCase() || .indexOf(), .lastIndexOf() || .replace() || .substr() || .trim()
|-
| [[Le langage HTML|HTML]] || <nowiki><br/></nowiki> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan>
|-
| [[SQL]] || <fontspan colorstyle="color:red">''rien''</fontspan> || <nowiki>||</nowiki>, concat || like %... || group by || count, length || upper()<ref>http://msdn.microsoft.com/fr-fr/library/ms180055.aspx</ref> || lower()<ref>http://msdn.microsoft.com/fr-fr/library/ms174400.aspx</ref> || like<br/>CHARINDEX()<ref>https://msdn.microsoft.com/fr-fr/library/ms186323%28v=sql.120%29.aspx</ref> || REPLACE() || substring()<ref>http://msdn.microsoft.com/fr-fr/library/ms187748.aspx</ref>
|-
| [[Visual Basic]] || _ || & || * || || len() || UCase() || LCase() || instr()<br/>''inverse :'' instrrev() || replace() || left(), mid(), right()
| [[Python]] || type() || self || del || time.sleep() || os.path.normcase(f) || ''fonction :'' return<br/>''boucle :'' break || import time... || import inspect...
|-
| [[Programmation Ada|Ada]] || || || ''automatique'' || <ttcode>delay </ttcode>''secondes''<ttcode>;</ttcode> || || ||
|-
| [[Programmation C|C]] || || *, ''déclaration :'' ... || free() || sleep || || ||
| [[Programmation JavaScript|JavaScript]] || getAttribute() || this || delete || window.setTimeout() || object.BuildPath(path, name) || return ||
|-
| [[Le langage HTML|HTML]] || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || <fontspan colorstyle="color:red">''rien''</fontspan> || ||
|-
| [[SQL]] || <fontspan colorstyle="color:red">''rien''</fontspan> || || delete || WAITFOR DELAY || || GETDATE() ||
|-
| [[Visual Basic]] || || .save, .saveas || Set MaVariable = Nothing<br/> Erase MonTableau<ref>Définit chaque ligne à ''Nothing''</ref><br/> Kill MonFichier ''ou'' filesys.DeleteFile MonFichier || Sleep<ref>Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)</ref> || dir() || ''fonction : ''Exit, End<br/>''fichier :'' .close<br/> goto || now()
| [[SQL]] || describe Matable Monchamp<br/>''T-SQL :'' SQL_VARIANT_PROPERTY(MonChamp, 'BaseType') || convert() || || || || create table Tableau || select * from Tableau || order by
|-
| [[Visual Basic]] || Typename() || CInt() || CDec || <fontspan colorstyle="color:red">''rien''</fontspan> || CStr() || Dim Tableau(2) As Integer || Tableau(1) || <fontspan colorstyle="color:red">''rien''</fontspan>
|}
!Langage!!Ouvrir!!Fermer!!Sauvegarder!!Écrire!!Paramètres des cellules
|-
| [[Programmation PHP/PEAR|PHP PEAR]]<ref>[[Programmation PHP/La librairie PEAR DB]]</ref> || <fontspan sizestyle=1"font-size:0.63em">$this->Spreadsheet_Excel_Writer_Workbook($filename);<br/>$workbook = new Spreadsheet_Excel_Writer();</fontspan> || $workbook->close(); || $workbook->sendFile(); || $worksheet->write(x,y,'Contenu'); || $format = $workbook->addFormat(<br/>array(<br/>'Size' => 10,<br/>'Align' => 'center',<br/>'Color' => 'black',<br/>'FgColor' => 'red'));
|-
| [[Programmation PHP/PHPExcel|PHPExcel]] ||
| 