excel
xlookup
nieuwe versie van vlookup
=XLOOKUP([@bplace];Sheet2!A:A; Sheet2!B:B; 0)
als klikbare links
=HYPERLINK(XLOOKUP([@Bestandsnaam]&".jpg"; Links!B:B;Links!E:E; "x" ))
Serial Communication in Excel 97
MSCOMM32.OCX
https://www.ocxme.com/files/mscomm32_ocx
Install the .OCX: Place 32-bit OCXs in the '/Windows/SysWOW64' directory and 64-bit OCXs in the '/Windows/System32' directory.
regsvr32 mscomm32.ocx
[HKEY_CLASSES_ROOT\Licenses\4250E830-6AC2-11cf-8ADB-00AA00C00905]
@="kjljvjjjoquqmjjjvpqqkqmqykypoqjquoun"
and restart excel 97
save python dict as Excel 97 file
import xlwt
# Gegeven waarden
values = {
'B1': '=SUM(C2:C6)',
'C1': 'Resultaten',
'C2': 5,
'C3': 4,
'C4': 3,
'C5': 8,
'C6': 12
}
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('Sheet1')
for cell, value in values.items():
col = ord(cell[0]) - 65
row = int(cell[1:]) - 1
if isinstance(value, str) and value.startswith('='):
worksheet.write(row, col, xlwt.Formula(value[1:])) # Verwijder '=' voor xlwt Formula
else:
worksheet.write(row, col, value)
filename = 'output.xls'
workbook.save(filename)
returns true, when an error occurs or when B2 is not 1 higher than B1
=IFERROR(VALUE(B2)<>VALUE(B1)+1, TRUE)
bewerk huidige cell
Control + U
freeze row / set row as header
View > Freeze Panes > Freeze Top Row