export data with chinese to CSV

Issue I am trying to export data containing chinese(some non-english characters for that matter) from ui-grid to pdf or CSV. However the exported text is all garbled. Here is the plnkr link http://plnkr.co/edit/ZR34lhm3LUNmUrj7Vg23?p=preview I understand for the pdf export to

Continue reading

Mirroring Range of Cells in Between Sheets

Issue Sheet1 Private Sub Worksheet_change(ByVal Target As Range) If Not Intersect(Target, Range("B93")) Is Nothing Then If Target = Range("B93") Then Sheets("Sheet2").Range("A1").Value = Target.Value End If End If End Sub Sheet2 Private Sub Worksheet_change(ByVal Target As Range) If Not Intersect(Target, Range("A1"))

Continue reading

SEARCH or COUNTIF excel range with INDIRECT

Issue I try to make this formula: =IF(COUNT(SEARCH(MID(D2;ROW(INDIRECT("1:"&LEN(D2)));1);"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))=0;"NO";"OK") works like this formula: =IF(COUNT(SEARCH({"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U";"V";"W";"X";"Y";"Z"};D2))=0;"NO";"OK") but its not working when cell starts with no letters. Solution What you are after is probably something like: =IF(SUM(IFERROR(SEARCH(MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ",SEQUENCE(26),1),D2),0)),"OK","NO") For versions prior to ms365, try: =IF(IFERROR(LOOKUP(99^99,SEARCH(MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ",ROW($1:$26),1),D2)),0),"OK","NO")

Continue reading

VBA paste range

Issue I would like to copy a range and paste it into another spreadsheet. The following code below gets the copies, but does not paste: Sub Normalize() Dim Ticker As Range Sheets("Sheet1").Activate Set Ticker = Range(Cells(2, 1), Cells(65, 1)) Ticker.Copy

Continue reading

Select range in a particular sheet in excel vba

Issue I have a question about selecting a range in a particular sheet using excel vba. I don’t know why the following is not working: Thisworkbook.Sheets(“N&A”).Range(“B4:F16”).select However this works: Thisworkbook.Sheets(“N&A”).Activate ActiveSheet.Range(“B4:F16″).Select The VBA code is programmed on “N&A” sheet. Could

Continue reading

Excel to HTML table

Issue I’m new to web programming and the first project that i’m working on is a web site that allows the user to see information from an Excel file (which is updated daily). I started from converting the Excel file

Continue reading

Why python request return html file instead of excel?

Issue I want to download excel file from this link via python https://www.tfex.co.th/tfex/historicalTrading.html?locale=en_US&symbol=S50Z21&decorator=excel&series=&page=4&locale=en_US&locale=en_US&periodView=A Here is my code: url = ‘https://www.tfex.co.th/tfex/historicalTrading.html?locale=en_US&symbol=S50Z21&decorator=excel&series=&page=4&locale=en_US&periodView=A’ resp = requests.get(url) with open(‘file.xls’,’wb’) as f: f.write(resp.content) But the file.xls is instead a html text file. file.xls looks like

Continue reading

Angular 6 generate excel file with sheetJs but removing some keys?

Issue I have this JSON: [{“name”:”peter”, “surname”:”cage”, “nickname”: “peterbob”, “city”:{“id”:130, “name”:”GreatCity”} }, {“name”:”james”, “surname”:”parot”, “nickname”: “mrj”, “city”:{“id”:142, “name”:”OtherCity”} }, …] I want to generate an Excel file using SheetJs js-xlsx for Angular 6, this is my attempt: const worksheet: XLSX.WorkSheet

Continue reading

SheetJS xlsx-cell styling

Issue I am referring this example to export a worksheet https://github.com/SheetJS/js-xlsx/issues/817. How to do cell styling like background coloring,font size and increasing the width of the cells to make the data fit exactly.I have gone through the documentation but couldn’t

Continue reading