Astuces Excel
  1. Astuces Excel
  3. Enregistrer et quitter l'object ActiveX
Intereting Posts
question openpyxl: l'autofilter provoque un bug sur les feuilles avec une parenthèse dans le nom Le code ne fonctionne pas pour le jeu de données pivots ayant des lignes> 65536 Erreur d'automation supprimant la feuille Validation Excel: Rejeter des inputs dans une colonne qui sont dupliquées ou non d'une gamme nommée Le calcul Excel UDF doit renvoyer la valeur 'originale' VBA: stocker la valeur à la variable Excel: Soustraire le time en négatif Afficher plusieurs heures supplémentaires et horodatages dans les lignes Labview Graphique de données pour afficher les heures de la journée dans Excel Le tableau généré dynamicment avec MODE.MULT pour les valeurs de la série graphique provoque l'effondrement de Excel 2010 Copiez les colonnes et collez uniquement les formules – pas les valeurs Match Columns puis search Augmentation automatique des cellules Exporter une collection IQueryable vers Excel Envoi du file Excel en pièce jointe dans sql

Enregistrer et quitter l'object ActiveX

J'essaie d'utiliser javascript pour envoyer des données à une list excel, append datatables à la list, save et fermer la list. Je sais que lorsque j'utilise ActiveX, je suis limité à IE, mais c'est correct.

Le problème auquel je suis confronté est que ni la méthode quit ni la méthode save ne fonctionnent. Le process rest ouvert et datatables ne sont pas enregistrées, sauf si je l'enregistre manuellement.

Voici le code: 

function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); newRow = "B" + (LastRow + 1); var m_names = new Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"); var d = new Date(); var curr_date = d.getDate(); var curr_month = d.getMonth(); var curr_year = d.getFullYear(); var dateNow = curr_date + m_names[curr_month] + curr_year; test.ActiveSheet.Range(newRow).value = dateNow; newRow = "C" + (LastRow + 1); test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; newRow = "D" + (LastRow + 1); internalOrExternal(); test.ActiveSheet.Range(newRow).Value = intOrExt; newRow = "E" + (LastRow + 1); test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; newRow = "F" + (LastRow + 1); test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; Excel.Quit(); }

Les documents MSDN https://msdn.microsoft.com/en-us/library/6958xykx(v=vs.100).aspx indiquent que la méthode fait partie de l'espace de noms de l'application, alors essayez d'utiliser Excel.Application.Quit(); au lieu. Il a également la syntaxe Excel.saveAs.

Bien que je comprenne qu'il s'agit d'un script pour IE uniquement, notez que IE Edge ne le prendra pas non plus, donc ce n'est pas du tout à l'avenir. Si vous avez access à certains outils côté server, il existe un tas de bibliothèques Excel là où vous pouvez utiliser avec les appels ajax. Personnellement, nous utilisons le module https://github.com/SheetJS/js-xlsx pour node.js

Ok alors pour toute personne intéressée par la solution. L'erreur que j'ai faite était que je n'ai pas rempli le formulaire complètement, de sorte que le code saute les parties de cette ligne de code sur: newRow = "B" + (LastRow + 1);

Cela entraînera l'appel de la méthode quit (). En commentant tout le code que je n'ai pas vraiment utilisé lors du test, le code fonctionne sans aucun problème.

En tant qu'informations supplémentaires, si quelqu'un est confronté à un problème semblable, lorsque vous utilisez la méthode saveAs (), vous pouvez save le file dans le même nom de file afin que saveas () puisse fonctionner comme une sauvegarde simple.

S'il vous plaît, consultez le code ci-dessous qui a fonctionné pour moi (le code que je n'ai pas utilisé pour le cas de test est commenté. C'est le code qui a été ignoré, ainsi que les deux methods save () et quit ()): 

 function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); } -> function getNumber() { var Excel = new ActiveXObject("Excel.Application"); var test = Excel.Workbooks.Open("pathToFile"); var LastRow = test.ActiveSheet.Range("A1").CurrentRegion.Rows.Count; alert(LastRow); var combine = "A" + (LastRow); alert(combine); var getCell = test.ActiveSheet.Range(combine).Value; var delimiter = '_'; var start = 3; var tokens = getCell.split(delimiter).slice(start); var result = parseInt(tokens.join(delimiter)); var newNumber = result + 1; whichCompany(); var newRow = "A" + (LastRow + 1); var id = "D_" + selectedName + "_2017_"+ newNumber.toSsortingng(); test.ActiveSheet.Range(newRow).Value = id; alert(id); <!-- newRow = "B" + (LastRow + 1); --> <!-- var m_names = new Array("Jan", "Feb", "Mar", --> <!-- "Apr", "May", "Jun", "Jul", "Aug", "Sep", --> <!-- "Oct", "Nov", "Dec"); --> <!-- var d = new Date(); --> <!-- var curr_date = d.getDate(); --> <!-- var curr_month = d.getMonth(); --> <!-- var curr_year = d.getFullYear(); --> <!-- var dateNow = curr_date + m_names[curr_month] + curr_year; --> <!-- test.ActiveSheet.Range(newRow).value = dateNow; --> <!-- newRow = "C" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("fName").value + " " + document.getElementById("lName").value; --> <!-- newRow = "D" + (LastRow + 1); --> <!-- internalOrExternal(); --> <!-- test.ActiveSheet.Range(newRow).Value = intOrExt; --> <!-- newRow = "E" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("case").value; --> <!-- newRow = "F" + (LastRow + 1); --> <!-- test.ActiveSheet.Range(newRow).Value = document.getElementById("produkt").value; --> test.SaveAs("pathToFile"); Excel.Application.Quit(); }

@Shilly: Merci pour le lien vers la documentation, cela a aidé à me mettre sur la voie de la solution.