How can I export/import settings of Sublime Text 3 from one PC to another using Windows?

The best way is to sync the User directory, there are multiple available ways to do this – dropbox, git and manual ways. Installed packages are registered in Package Control.sublime-settings, which is located in the user folder as well, thus, it does not require you to sync anything besides that. A pretty good guide to … Read more

Export subtree in Git with history

Quoting an example from git-filter-branch(1) To rewrite the repository to look as if foodir/ has been its project root, and discard all other history: git filter-branch –subdirectory-filter foodir — –all Thus you can, e.g., turn a library subdirectory into a repository of its own. Note the — that separates filter-branch options from revision options, and … Read more

Export DataTable to Excel with EPPlus

using (ExcelPackage pck = new ExcelPackage(newFile)) { ExcelWorksheet ws = pck.Workbook.Worksheets.Add(“Accounts”); ws.Cells[“A1”].LoadFromDataTable(dataTable, true); pck.Save(); } That should do the trick for you. If your fields are defined as int EPPlus will properly cast the columns into a number or float.

Export to CSV using jQuery and HTML

Demo See below for an explanation. $(document).ready(function() { function exportTableToCSV($table, filename) { var $rows = $table.find(‘tr:has(td)’), // Temporary delimiter characters unlikely to be typed by keyboard // This is to avoid accidentally splitting the actual contents tmpColDelim = String.fromCharCode(11), // vertical tab character tmpRowDelim = String.fromCharCode(0), // null character // actual delimiter characters for CSV … Read more

Exporting an array in bash script

Array variables may not (yet) be exported. From the manpage of bash version 4.1.5 under ubuntu 10.04. The following statement from Chet Ramey (current bash maintainer as of 2011) is probably the most official documentation about this “bug”: There isn’t really a good way to encode an array variable into the environment. http://www.mail-archive.com/bug-bash@gnu.org/msg01774.html

phpexcel to download

Instead of saving it to a file, save it to php://outputĀ­Docs: $objWriter->save(‘php://output’); This will send it AS-IS to the browser. You want to add some headersĀ­Docs first, like it’s common with file downloads, so the browser knows which type that file is and how it should be named (the filename): // We’ll be outputting an … Read more